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@gmail.com> wrote:

> 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.

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

> 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.

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/