Skip to Content.
Sympa Menu

freetds - [freetds] Problem with OTL & bulk insert

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Piet De Jong" <piet AT ahead-tech.net>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Problem with OTL & bulk insert
  • Date: Wed, 28 Jul 2004 16:56:04 +0200

Hello,

Attached a simple little test program that is supposed to batch-insert a
number of rows.

What's supposed to happen ( and works on Windows + ODBC ) is that the insert
statements are buffered in batches of 50 and then send to the database.
This saves 49 round-trips for every 50 inserts.

Unfortunately this does not seem to work on freetds ( or not implemented ).
It seems to only insert the first one of every batch.

If I change the buffer-size for the insert to 1, then it works fine ( also
the select statement with a buffer of 50 )... However this defeats the
performance issue.

Currently I am using version: freetds-0.63.dev.20040514.tgz

attached are:
- sample source code
- odbctrace file
- otlv4.h file

( ps I am using libiodbc-3.51.1 )
Please advise if you need more information.

Best regards
Piet

Attachment: buftest.tgz
Description: Binary data




Archive powered by MHonArc 2.6.24.

Top of Page