topic Re: Net runtime is differing every time in SAT ? in Application Development and Automation Discussions

Net runtime is differing every time in SAT ?

Former Member — Tue, 05 Apr 2016 10:29:31 GMT

Hello developers,

I am using SAT to analyse the performance on a report, report has no code except a select query on a table to extract all records, but for my every execution, the net run time is differing noticeably, (ex, : 1st trace run time came around 502806 microsec and 2nd runtime around 146224 microsec), all this without any change in the no.of records! what might be the case?, can anyone tell me where I am going wrong?

Re: Net runtime is differing every time in SAT ?

Ashg1402 — Tue, 05 Apr 2016 10:40:40 GMT

Hi,

the trace run time can depends on many factors like current state of DB, Cache memory, sometimes even connection speed. You are not going wrong.

Regards

Ashish

Re: Net runtime is differing every time in SAT ?

Former Member — Tue, 05 Apr 2016 12:53:22 GMT

I think in this special case the cache of the database server takes into account.

I had a similar behavior in the past with a program. Everytime I started a trace on the program in the morning, it takes some time for all the SELECTs. Every further trace at the day took only a small amount of time for the SELECTs.