Problem with posting 40000 lines in item journals

cojnaviworld · 2008-04-24

Hi Guys

I have a big problem with a potential customer who are running on 3.70 NAITIVE and they have a very big problem because it's a VERY big company with retails shop and they import around 40000 item lines into a item journal but when they want to post it's blocked the hole system for more than 2 hours, and now I have to find a solution for them.

Can any of your guys propose any specific things to look at?? (I will look at the keys and the code the former dev. have make) but something else or maybe there is standard problem in 3.70??

I hope you guys can help me with a solutions

THANKS in advance

rvduuren · 2008-04-24

Assuming your customer uses native NAV database server, the first thing I thought was: MSSQL-NAV, Recordlocking..

cojnaviworld · 2008-04-24

Hi Rvduuren

They are using a Naitive server :-((

So what to do??

kriki · 2008-04-24

Use as much cache as possible. And use the COMMIT-cache (make sure have some battery backup).
Divide the DB into multiple DB-files. All of them on their dedicated (ONLY THAT DB-FILE!!!) RAID1-pairs.
Try not to superate 5GB per DB-files (and thus per disk).

ara3n · 2008-04-24

See if you can combine the lines. For example

Item A sold qty 1 location C At price 10
Item A sold Qty 2 location C At price 10

you can change it to one line
Item A sold qty 3 location C At price 10

You need to run the client from the server. Increase the cache of the client.

matteo_montanari · 2008-04-24

cojnaviworld wrote:

Hi Guys

I have a big problem with a potential customer who are running on 3.70 NAITIVE and they have a very big problem because it's a VERY big company with retails shop and they import around 40000 item lines into a item journal but when they want to post it's blocked the hole system for more than 2 hours, and now I have to find a solution for them.

Can any of your guys propose any specific things to look at?? (I will look at the keys and the code the former dev. have make) but something else or maybe there is standard problem in 3.70??

I hope you guys can help me with a solutions

THANKS in advance

Hi

Post first 400 Lines, COMMIT and wait some seconds and so on...

Eto

matttrax · 2008-04-24

You could use the Job Queue and NAS to schedule it to automatically run in the middle of the night.

kine · 2008-04-24

Eto wrote:

cojnaviworld wrote:

Hi Guys

I have a big problem with a potential customer who are running on 3.70 NAITIVE and they have a very big problem because it's a VERY big company with retails shop and they import around 40000 item lines into a item journal but when they want to post it's blocked the hole system for more than 2 hours, and now I have to find a solution for them.

Can any of your guys propose any specific things to look at?? (I will look at the keys and the code the former dev. have make) but something else or maybe there is standard problem in 3.70??

I hope you guys can help me with a solutions

THANKS in advance

Hi

Post first 400 Lines, COMMIT and wait some seconds and so on...

Eto

But do not forget to delete these posted lines before you call commit, else next run or in case of error you will be posting the lines again... :!:

Problem with posting 40000 lines in item journals

Comments

Categories