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: 152
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.
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: 1498
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
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: 152
Registered: October 2014
Senior Member
Thanks Dimitris.
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.
Previous Topic:Populate model with values stored written in a file
Next Topic:Deployment of Epsilon artifacts
Goto Forum:
  


Current Time: Thu Jan 18 13:27:38 GMT 2018

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

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