Maximum no. of Items

McFarmer

Hi all!

We (ShopBusters) just started a new Internet Warehouse. What I'd like to know is whether there is a maximum no. of items that can be placed in the item and related tables. When everything is up and running we need to place 7.000.000 items and related things like prices etc. in Navision.

We use MBS-Navision 4.0 SP2 in combination with a SQL-database.

Does anyone have any experience with this?

Tnx in advance

Romke

Phenno

McFarmer wrote:

Hi all!

We (ShopBusters) just started a new Internet Warehouse. What I'd like to know is whether there is a maximum no. of items that can be placed in the item and related tables. When everything is up and running we need to place 7.000.000 items and related things like prices etc. in Navision.

We use MBS-Navision 4.0 SP2 in combination with a SQL-database.

Does anyone have any experience with this?

Tnx in advance

Romke

Phoooooh... Code field (Item's No.) is 20ch long (characters!) which means, you can make billions of items with different No. (cause you may mix characters, numbers, etc...). You have no restriction there (or anywhere in Navision).
But, you'll have to spend a lot of time to get optimal run-time parameters for a large system as yours....

Marije_Brummel

Are the items you want to register the songs you can download from the website? Like your shopbusters.nl site?

My advise is not to use items for this but to make a special customised subsystem that is tuned for this purpose.

You can e.g. make the primairy key an integer instead of a code, what makes it for SQL a lot easier.

Contact me for details if you like.