Report taking lot of time

upasanisandip
upasanisandip Member Posts: 405
edited 2007-08-13 in NAV/Navision Classic Client
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.

Comments

  • kine
    kine Member Posts: 12,562
    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.)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    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.
    Marije Brummel | Freelance Business Central Specialist

Categories