MySQL Forums
Forum List  »  Router & Proxy

rewrite queries to optimize WAN speed
Posted by: Bart Van Hoecke
Date: July 22, 2010 05:52AM


I would like some thoughts and feedback on the following idea:

Many mysql-client applications are badly written in terms of network latency: instead of one multivalue insert, they would loop through several individual inserts, requiring a network roundtrip for each insert.

I have created a mysql-proxy script that translates sequential inserts into a multi-value insert, and I would like the community's feedback on this idea.
Bare with me, this was my first lua script :-)

I may have overlooked pitfalls or problems...

Many thanks!

Options: ReplyQuote

Written By
rewrite queries to optimize WAN speed
July 22, 2010 05:52AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.