Link Details

100K registers?!? I guess they mean records...

And seems to be doing it by concatenating strings into SQL statements, which I would have thought was a very bad way of doing it...

What's wrong with a prepared statement in batch mode?

Yes, records.

String concat is only done in MySql... which seems to be the fastest way (and faster than firebird and sqlserver)

Prepared statements like in Java? Because a prepare actually happens after the first call. Can you send some links in C#? I don't find an equivalent to executeBatch

Sorry, yeah I meant using a SqlDataAdapter and transactional control to commit after a "batch" of inserts had been done

My comment was when my head was in "java mode" (I've been doing Perl all morning, and it scrambled my brain) ;-)

Thanks bloid.

Yes, I've seem samples in Perl and Java, but not in C#.

Do you think a SqlDataAdapter will be faster than directly issuing commands with a IDbCommand inside a transaction?

I'll check.

this article really doesnt explore all the options. I got 1 million records to insert in 17 seconds with SqlBulkCopy...

http://blog.stevienova.com/2008/01/16/net-fastest-way-to-load-text-file-to-sql-sqlbulkcopy/


,

Bulk Copy is WAY faster.