Excessive queries while load balancing
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?
Subject
Written By
Posted
Excessive queries while load balancing
September 20, 2013 03:12AM
September 24, 2013 08:46AM
September 26, 2013 07:29AM
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.