‎2016 Apr 05 11:29 AM
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?
‎2016 Apr 05 1:53 PM
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.
‎2016 Apr 05 11:40 AM
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
‎2016 Apr 05 1:53 PM
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.