Processing Multiple Day's DST Files

DST will continue to put files on their server as long as you retrieve them once in 30 days.  HOWEVER, processing 30 days of files all at once can present some computer resource problems:

1.You may not have enough memory in your workstation to process that many files, especially if Nationwide is one of your vendors.  If Nationwide is a vendor, you will need a minimum of 2GB memory in your workstation and should limit your processing to 5 days at once.

2.SQL Server Express contains a 4GB database limit.  The Nationwide price files must be stored in the database on a temporary basis before they can be processed.  During processing we insert only the prices that your clients need and the rest of the prices are discarded at the end of the process.  Nationwide sends over 350,000 prices even if you only have one client with one product.  Temporarily storing 30 days worth of prices is over 10 million prices just to get a few into your price file can use a significant part of the 4GB limit.

See Also