When a post a sales order with 100-150 lines is getting around 5 min, on another hand we have sales order with more than 100000 lines. during that time nobody can post during that time .
I uncheck automatic cost posting
i did automatic cousc adjusment to monthly
but still it's getting to much time, I strat posting on batch at 11 on nighti and still didnot finsh
any ideas?
P.S
NAV 5.0
SQL 2005
0
Comments
2. Are there some customized tables
3. Are there some custumized indexes
4. Are there some customized SIFTS
5. Are there Maintenance Jobs on the SQL Server
6. Did you check why the system is slow?
7. Follow the LINK and read some posts in the "SQL Perfomance" Subforum.
x. If you doesn't know how to solve this, call your NAV partner. If you are NAV partner and you can't solve it, ask for a NAV / SQL specialist on the forum here.
Regards
Do you have "Analysis View" for which "Update on Posting" is 'yes' ?
But oh my foes and oh my friends, it gives a lovely light
If that was not a typo, and your client really has orders with 100,000 lines then you need to think about getting some serious help on this project.
Value costing can do this in some circumstances, which is why many companies run adjust cost as a batch job every night.
100 to 150 lines in a sales order will not be instantaneous, but it should not take 5 minutes easier.
100,000 lines - what are you doing? (And should you be doing it?)
http://mibuso.com/blogs/davidmachanick/