Purchase Order Posing Speed slow

EknathPPawar

Dear All ,

while posting from purchase order receive and invoice takes a lot of time , can any any one suggest a solution for the problem. I have tried using Database- information - tables - optimize Database used is native.

Regards

eknath

themave

Not a lot of things that I know of, but if you have analysis views that update on posting, this can slow things down, especially on the sales order side

We have found purchase order receiving is a very intrusive routine. it will lock tables needed for sales order posting. so our sales people are constantly complaining about being locked by userid ....., it is always comes back to they were receiving a po. We have moved times that people can do receiving to a slow sales period.

nunomaia

In this forum there are many topics about that subject. It depends a lot on your current configuration and other settings.

Search this forum if one of the many answer can fit to your problem.

themave

nunomaia wrote:

In this forum there are many topics about that subject. It depends a lot on your current configuration and other settings.

Search this forum if one of the many answer can fit to your problem.

sorry but searching the forum is more art then science, I searched for PO posting is slow, that return 40 pages of search results having little to nothing related to the search.

then I did the same search but said to match all terms, it returned one page of listings, off which had little to do with the "po posting slow"

I think a few of the post where suggestions to search the forum for the solution.

sorry about the rant, but saying search the forum, rather then adding something constructive does little to help anybody.

nunomaia

Ok,
Probably you are right. :-)

http://www.mibuso.com/forum/viewtopic.php?t=6856
http://www.mibuso.com/forum/viewtopic.php?t=5023
http://www.mibuso.com/forum/viewtopic.php?t=16806
http://www.mibuso.com/forum/viewtopic.php?t=7528

Alex_Chow

EknathPPawar wrote:

Dear All ,

while posting from purchase order receive and invoice takes a lot of time , can any any one suggest a solution for the problem. I have tried using Database- information - tables - optimize Database used is native.

Regards

eknath

1. SQL or Native?
2. What modifications are done?
3. How many lines?
4. How big is your DB?
5. How fast is your disk drive?
6. What's your cache?
7. What's the memory on your server? client?
8. What's the RAID setup on your server?
9. Have you tried searching regarding performance?