Inserting Records into SQL Server - is there a faster interface than ADO
Oren Tirosh
oren.tirosh at gmail.com
Mon Nov 14 10:00:20 EST 2005
> We are using the stored procedure to do a If Exist, update, else Insert processing for
> each record.
Consider loading the data in batches into a temporary table and then
use a single insert statement to insert new records and a single update
statement to update existing ones. This way, you are not forcing the
database to do it one by one and give it a chance to aggressively
optimize your queries and update the indexes in bulk. You'd be
surprized at the difference this can make!
More information about the Python-list
mailing list