11113.1 InventonHandItem form performance killer

11113.1 InventonHandItem form performance killer

Post by bWlrZW9ha2 » Wed, 27 Apr 2005 09:13:03


Hi

When I open up the inventonhanditem form from the inventory - inquiries - on hand form, this kills performance.


The SQL CPU goes to 100% and this affects all users. It takes on average 10 seconds to open up the form, the super call in the inventSum datasource is where it is slow. I switched on long queries and this process appears in the long query file created.


Any suggestions?

Thanks

Mik

technet.navision.com Posting date: Wednesday, October 13, 200

technet.navision.com Posting path: Navision Axapta/Technology (Ax)/Performance
 
 
 

1. 11113.3 InventonHandItem form performance killer

2. 11112.1 InventOnhandItem - Performance Killer ?


Under Inventory/Inqueries there is a menuitem for seeing all inventory joined by the item/dimensions. To call this takes a looooooooong time.

Has anyone else come aross this problem? Opening up the form KILLS the CPU and all users are affected.

Thanks

Mik

technet.navision.com Posting date: Wednesday, October 13, 200

technet.navision.com Posting path: Navision Axapta/Technology (Ax)/Performance

3. 6752.1 InventOnhandItem - Performance Killer ?

4. background image performance killer

5. sensor class performance killer?

6. Silent performance killer with promoted column

7. A Killer Email Message - How to Write Killer Email Promos that Get Results

8. Frame Killer Killer

9. A Killer Email Message - How to Write Killer Email Promos that Get Results

10. Ultimate Virus Killer 2000 - Atari ST/TT/Falcon virus killer