Skip to content

Insert multiple rows in a single command #362

Open
@ehansen486

Description

@ehansen486

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

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions