Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » Epsilon » Execution time for ETL transformation(different ETL transformation execution time )
Execution time for ETL transformation [message #1777351] Tue, 28 November 2017 18:09 Go to next message
taghreed altamimi is currently offline taghreed altamimiFriend
Messages: 184
Registered: October 2014
Senior Member
Hi,
I used Epsilon Profiling Tools to measure the execution time for ETL transformation.I noticed that the first run the execution time was 399 ms and the second run the execution time was 190 ms even though i didn't change the rules or the models.
Does ETL engine use any kind of cashing??
What do you recommend to measure ETL transformation time?? I mean can i depend on profiling tool to get the correct execution time for ETL transformation?


Thanks,
Taghreed.

Report message to a moderator

Re: Execution time for ETL transformation [message #1777368 is a reply to message #1777351] Tue, 28 November 2017 22:49 Go to previous messageGo to next message
Dimitris Kolovos is currently offline Dimitris KolovosFriend
Messages: 2163
Registered: July 2009
Location: York, UK
Senior Member
Hi Taghreed,

I suspect it's the JVM getting warm. The profiling tools are reasonably accurate.

Cheers,
Dimitris

Report message to a moderator

Re: Execution time for ETL transformation [message #1777694 is a reply to message #1777368] Fri, 01 December 2017 16:01 Go to previous messageGo to next message
taghreed altamimi is currently offline taghreed altamimiFriend
Messages: 184
Registered: October 2014
Senior Member
Thanks Dimitris.

Report message to a moderator

Re: Execution time for ETL transformation [message #1777828 is a reply to message #1777694] Tue, 05 December 2017 05:17 Go to previous message
Qamar uz Zaman is currently offline Qamar uz ZamanFriend
Messages: 10
Registered: November 2017
Junior Member
The execution time depends on the scheduling algorithm of the operating system and it may also get affected if the operating system is execting other routines like memory management, Io management etc.
It is better to calculate the average time for a task.

Report message to a moderator

Previous Topic:Populate model with values stored written in a file
Next Topic:Deployment of Epsilon artifacts
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 09:13:42 GMT 2024

Powered by FUDForum. Page generated in 0.03610 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly