Physical Inventory

Posted by MAS on February 16, 2007, 12:21 pm

Please log in for more thread options

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?

Posted by Glenn Adams [MVP - Retail Mgmt on February 16, 2007, 1:34 pm

Please log in for more thread options

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 Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.

MAS wrote:

> 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?