Re: multiple update in one request possible?
Rudy Lippan <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Message-ID | <[email protected]> |
> 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/[email protected]