From: José Rómulo Elías Contreras (romuloacerosocotlan.com.mx)
Date: Thu Feb 17 2005 - 09:08:44 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello:

I test the performance of SAPDB in two tomcat servers connecting to the
same database. Each tomcat server open 10
sessions with the next parameters:

DriverManager.getConnection(databaseUrl + databaseName + "?user=" +
databaseUser + "&password=" + databasePassword + "&timeout=0&isolation="
+ java.sql.Connection.TRANSACTION_READ_UNCOMMITTED);

    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.

    I measured the time before calling the execute method of the
statement, and afterwards:

    // Before execute statement save time (time1)
    ResultSet rs = statement.executeQuery( sql );
    // After execute statement save time (time2)
    // differenceTime = time2 - time1

Why does the performance go down?
Why can I correct it?

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]