Re: SAPDB performance, HELP PLEASE!!!!!

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

-- 
x1@xxxxxx
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/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx