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?
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 RAMGlenn Adams Tiber Creek C> our Sku file is in excess of 125,000. When we are importing our csv file with
Have something to add? Share your thoughts — no account required.
Ask the community — no account required