|
|
Choosing A Webhost: |
SAPDB performance?: msg#00216db.maxdb
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 To unsubscribe: http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx
|
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | MAXDB / SAPDB MAPCHARSET UNICODE Problem Solution :))), Mr Rusen Ozsoy |
|---|---|
| Next by Date: | SAPDB performance?, José Rómulo Elías Contreras |
| Previous by Thread: | MAXDB / SAPDB MAPCHARSET UNICODE Problem Solution :))), Mr Rusen Ozsoy |
| Next by Thread: | SAPDB performance?, José Rómulo Elías Contreras |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business. subscribe Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field. subscribe The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business. subscribe Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company. subscribe Total Telecom Total Telecom is "The Economist of the communications industry". subscribe |
Home
| advertise | OSDir is
an inevitable website.
|