My application (LabVIEW with ADODB._Connection) produces 1000 new float values every 10ms. Unfortunately it takes 600 ms to insert these values row wise into my 1000 column table, using the folowing command:
INSERT INTO Benchmark_Table VALUES (404,0.000,0.136,0.807,0.633,0.372,0.530,... );
Is this something I have to live with, or is there a faster way to do that?
I'm using SQL Server 2008 R2.
View Complete Post