jwcolby
jwcolby at colbyconsulting.com
Tue Apr 29 00:15:45 CDT 2008
OK, it is running in a loop now, processing 10K records every 19 seconds. It will take 50 hours at the current rate to parse 96.4 million records, or about 2 million records / hour. the SQL Server update portion is taking about 5 seconds of each 19 second cycle, 14 seconds to parse, 5 seconds to write back to the database, virtually nothing to load. At least it is running now, making progress. Thanks for all the help from everyone getting this thing to happen. -- John W. Colby www.ColbyConsulting.com