[dba-VB] Name parsing system timing

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



More information about the dba-VB mailing list