Hello,
I have a "slight" problem with the mySQL C API. I want to bind vectors
for output/input prepared statements. However, the C API does NOT
support such data binding. Is there ANY other way to do a
bulk-INSERT/DELETE/UPDATE or bulk-SELECT in mySQL C API? I mean, one
can do it with a loop, but obiously the goal is to have a higher
performance.I tried it with a plain-old loop, but it is still slow.
Oracle supports such feature and it is considerably faster than the
usual loop-Insert (appr. 100 times faster for big queries) ! ! !
Please, advise.

Thanx.

Regards,

Dragomir Stanchev

"The|Godfather" <dragomir.stanchev (AT) gmail (DOT) com> wrote:

Right. This extension of the PS API is already on the TODO list.

I doubt the client API being the reason for slow bulk loading. How did
you come to this conclusion?

The fastest method for bulk loading is LOAD DATA INFILE. Multi value
INSERT (non-prepared) and single value INSERT (prepared) are
approximately equally fast.

For more tips regarding INSERT performance, please consult the manual:
http://dev.mysql.com/doc/refman/5.0/...ert-speed.html


XL
--
Axel Schwenke, Senior Software Developer, MySQL AB

Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/