I'm not sure why you'd be scripting something that can be done directly, unless you're using a script to modify the data in some way. If you just modify the data, how long does that take? Write the modified data to a file and trigger an import command rather than feeding each record individually.
I collect event log data from around 80 crucial servers each night.. the script I wrote filters the raw data and converts it to a format I need, stripping out certain records based on content or record type. The resulting files are then fed to a SQL server for import. Hundreds of thousands of lines of data being processed and it runs in about 90 minutes. When I tried writing directly to the SQL server, it took over 7 hours.
Glenn
_________________________
Actually I
am a Rocket Scientist!
