Physical Inventory

our Sku file is in excess of 125,000. When we are importing our csv file with our new counts it seems as it is never ending. We had to end the process because we let it run overnight and it still did not finish importing file.

Is there a way to speed up this process?

Reply to
MAS
Loading thread data ...

This probably isn't going to help you with this one, but break your physical inventory down by by department or category rather than doing one big count. This lets you load a bunch of small files instead of one huge one.

You could also try the following:

1) dedicate the SQL Server to running only SQL Server - add gobs of RAM 2) dedicate the workstation you are processing the Phy. Inv. on to only that task - again, add RAM

Glenn Adams Tiber Creek C> our Sku file is in excess of 125,000. When we are importing our csv file with

Reply to
Glenn Adams [MVP - Retail Mgmt

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.