|
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?
>
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap
> 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?
>