Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Net runtime is differing every time in SAT ?

Former Member
0 Likes
571

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?

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
531

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.

2 REPLIES 2
Read only

Ashg1402
Contributor
0 Likes
531

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

Read only

Former Member
0 Likes
532

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.