Largest amount of items in inventory

kalintsv

Hi,
what is the largest amount of items in inventory you have seen with native database? What about SQL database?

I am a little bit concerned for a client that is working with 600 000 items and about 20 locations which are going to work remotely.
Do you think there will be any performance issues?

Any suggestions are welcome.

Thank you in advance.

Kowa

If there are that many items filtering on non-key fields can take long, especially after the server has just started and the cache isn't yet filled. When a number of users have made similar filterings much data is retrieved from the cache and the response times are much quicker (set the DBMS Cache to maximum (1 GB))

One massive problem though is the Phys. Inventory Journal. If you calculate the inventory for 600000 Items, this will take many hours, and to post it will take many hours too. If the annual stocktaking is done for all 20 locations on the same day it is virtually impossible to calculate 20 different Phys. Inventory Journals on time, and the subsequent posting will take days. You will have to perform this on separate days throughout the year for the different locations.
If you limit the Phys. Inventory Journal calculation to the items that actually are in stock you might reduce the amount of lines in the journals drastically, ask you client how many of these items approximately really are in stock.

jjbogart

dear kalistv

we have around 2.500.000 items in out navision, with native database.
of course you need to index the item field so navision can find the items faster. we are really satisified as the searching in done quite fast most of the times in less than a second but only in one locati0n and one server

in case you have scsi 15.000 rpm it is much better for you database as we have



i do not know fi tis can help you out.

kalintsv

really will be in stock about 20 000

Timo_Lässer

jjbogart wrote:

[...] we have around 2.500.000 items in out navision, with native database.
[...] we are really satisified as the searching in done quite fast most of the times in less than a second [...]

Do you only search on key fields with best key selected before or how do you get such a performance? :-k
If you do so, I congratulate. Only the fewest users know that they could accelerate the search by selecting the best key before. =D>