multiple update in one request possible?

I'm looking for a method, to submit multiple update commands in one request.
I have a performance bottleneck, updating 20.000 records with sepperate upd=
ate statements. I assume, that one reason for this problem is, that the who=
le overhead of submitting the request has to be done for each command.
Is there a way, to submit more than one Command at a time to the database s=
erver?

Best regards
Josef


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org

Re: multiple update in one request possible?

> I'm looking for a method, to submit multiple update commands in one request.
> I have a performance bottleneck, updating 20.000 records with sepperate update statements. I assume, that one reason for this problem is, that the whole overhead of submitting the request has to be done for each command.
> Is there a way, to submit more than one Command at a time to the database server?
>

DBD::mysql does not have ability to do this right now; And even if it did,
set_server_option() is not supported in version of mysql older than 4.1.1, so
you would have to be using aversion of mysql greater than 4.1.1 (are you?). If
you are using 4.1.1, you have server-side placeholder support which should make
the update requests much faster since you don't have to re-send and re-parse the
statement every time. Also, note that you won't be able to use server-side
placeholders with multiple statement support.


But if you want to try it, I can send you a patch that will allow you to send
multiple update statements.


Oh and BTW what does your update logic look like, and do you have indices on the
columns that you are searching on?

Rudy.

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org