Description
I am using Mac and ubuntu. I am using the 1.3.0 version of tiny_tds. I am using freetds v1.00.40.
I want to insert many rows in a single insert statement.
In MySQL, it's possible to just post an insert statement with many (..), (..) stanzas after the values keyword and it tends to figure things out pretty efficiently. SQL*Server supports this syntax as well, but it is very very slow.
I read about sp_prepare, and the Java JDBC driver for SQLServer seems to leverage that, judging by the source code. I tried crafting a giant insert prepared statement (1000 rows * 100 columns kept SQLServer's CPU pegged). I still can't figure out how to efficiently post multiple rows for the same insert statement.
Anybody have any pointers on how to do this via the tiny_tds library?
Thanks!
Eric