Is this the fastest way to insert 100k rows into a database?

[InfiniteNothing]

I'm looking to insert ~100k rows into a database as fast as possible. I'm connected to the database through a small LAN with static IP adresses. The target database is running my SQL. Here's the fastest I've gotten the code so far. Task manager shows that it's only sending like 2.5mbps. If I take the size of the 2D array (64MB) and divide by the time it takes to transfer it currently, I calculate ~160kbps. Is that the best I can hope for with the NI DB Toolkit?

[Himanshu_Goyal]

Hi,

Use DB Tool Insert Data VI to insert the data in the database.

You can insert complete row data at a time. No need to insert single-single element in database this will reduce your code performance.