pysome has asked for the wisdom of the Perl Monks concerning the following question:
Hey ,Monks
I am using DBI::Sybase and FreeTDS to connect SqlServer 2K.
Now i need to insert into some data into db's table.
To speed,i delete the index in that table.Then i start inserting and calculating the rate of insertion as following.
it spent 35 minutes inserting about 310,000 items.That is,9000 /m or 150/s or so.
How about its speed on your experience?
I am using DBI::Sybase and FreeTDS to connect SqlServer 2K.
Now i need to insert into some data into db's table.
To speed,i delete the index in that table.Then i start inserting and calculating the rate of insertion as following.
it spent 35 minutes inserting about 310,000 items.That is,9000 /m or 150/s or so.
How about its speed on your experience?
Thanks
-Pysome
Back to
Seekers of Perl Wisdom