On Friday 18 February 2005 23:37, Jos� R�mulo El�as Contreras wrote: > I open 4 differents browser sessions connected 2 to each tomcat > server. If I request the same information in each different browser > session at the same time the performance go down. The first session > connected to tomcatServer1 takes 9 seconds to execute the query, the > second session connected to tomcatServer1 takes 12 seconds to execute > the query, the third session connected to tomcatServer2 takes 14 seconds > to execute the query and the fourth session connected to tomcatServer2 > takes 16 seconds to execute the query aproximately. If I open only one > browser session to execute the query, then the query takes only 3 seconds.
Well, your situation is not really clear to me but if I interprete you right, you do 4 simultaneous queries to your database and this lasts longer than applying the 4 queries sequentially - is that correct? I would recommend you to isolate the problem by testing these situations: 1) Use only one Tomcat server - is there a difference if you use two or not? Perhaps there is a problem when using multiple Tomcat server? 2) Do your SQL queries in e.g. websql and measure it there, so you will find out if this is a database problem or a tomcat issue. 3) Check, if the queries in some way hinder each other - perhaps due to cache issues or similar problems. Regards, Hermann -- [EMAIL PROTECTED] GPG key ID: 299893C7 (on keyservers) FP: 0124 2584 8809 EF2A DBF9 4902 64B4 D16B 2998 93C7 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
