Excessive queries while load balancing
Posted by: Egor Korobitsin
Date: September 20, 2013 03:12AM

Where there are many little queries, loadlbalance reduces entire performance.

Possible reproduction: there is some application that makes many ajax-queries to database. For example, with single database and without loadbalance in jdbc, it takes about 1 minute. But when I insert "loadbalance" in url and add second mysql server, it takes 1min 25sec.

Maybe this isn't a bug. But I need to avoid this excessive time. Could anybody please prompt me where I can look at the connector/J's code to find out why performance is reduced?

Options: ReplyQuote


Subject
Written By
Posted
Excessive queries while load balancing
September 20, 2013 03:12AM


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.