Report taking lot of time

upasanisandip

Hi all,
I have made one report . When I execute that report it is showing counter for every table. Sales Invoice Line, Item Ledger Entry.

I have used keys (SETCURRENTKEY).

Any other solutions to run the report faster?

Suggesstions are welcome.

Thanks.
Sandip.

kine

1) Still, it seems that you are not using correct keys. Check which fields you are filtering and which key you are using.
2) You can try to use client monitor and the "extended client monitor" objects (can be downloaded in download section) to collect more info about your problem (filters, used keys, incorrect FIND-NEXT usage etc.)

Marije_Brummel

Be carefull with SETCURRENTKEY, especialy in SQL2005 because it translates to ORDER BY which in a worst case causes a lot of TempDB activity for reports. Better is to let SQL decide which key to use.

Also UI can cause a lot of overhead. Try to only update your window after every 100 records or something.

If you use Profiler, whach for FETCH API CURSOR which can cause a lot of headaches.