Re: Thanks: Re: Fed up to the back teeth with tomcat !!!
- Original Message - From: "Jeff Kilbride" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; "Andy C" [EMAIL PROTECTED] Sent: Wednesday, April 11, 2001 11:25 PM Subject: Re: Thanks: Re: Fed up to the back teeth with tomcat !!! Hi Andy, Did you ever post your configuration? I would be interested in what OS; Tomcat/Apache versions; JVM; DB backend and driver; whether or not you're I have to admit that the configuration is a little complex, mostly because of legacy database and servlets left over from the JavaWebserver version. Here goes though: Server is NT2000 Apache is 1.3.12 with mod_jk Tomcat is 3.2.2.b2 (I upgraded from 3.2.1 in the hope it would fix the problem.) JVM is 1.1.6 (old version but it's the only one that would run a legacy servlet) Databases are: mysql 3.23.28 (Handles all the main jsp stories) SQL server V7 (Handles servlet requests for release dates) JDBC bridge to mysql is mm-mysql-2.0.4 JDBC-ODBC bridge for SQL server (This could be the problem) Hope this is of interest. Andy C Editor R2 Project http://www.r2-dvd.org
Re: Thanks: Re: Fed up to the back teeth with tomcat !!!
If I were to pick the weakest link, it'd probably be the jdbc-odbc bridge. FYI, for my own stress tests, I was able to run 24 hours at 20+ hits/second using Tomcat 3.2.1, IBMJava2-13, Apache 1.3.19, mod_jk w/ajp13, into a MySQL 3.23.35 database. This was all running on a fairly cheap linux box -- RedHat 6.2, 2.2.17 kernel, 128MB RAM, everything on one IDE drive. I was using a test suite with 25 concurrent threads on another machine (WinNT) connected by a 100bT ethernet doing simple insert statements. I actually got the Tomcat/Linux box up to 54 inserts per second, but the load average skyrocketed so I cut it back to something reasonable. Almost 2 million records into my database without a glitch. I was actually very surprised by the performance, since I hadn't tweaked anything and I was using the default Tomcat config. Granted, my test was pretty simple. I was only using one servlet and no .jsp pages. Are there any alternatives to the jdbc-odbc bridge? I thought that you used to be able to use the Sybase drivers to connect to MS-SQL -- but that may have been a long time ago and, obviously, nothing that was every officially supported. Thanks, --jeff - Original Message - From: "Andy C" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 12, 2001 12:22 AM Subject: Re: Thanks: Re: Fed up to the back teeth with tomcat !!! - Original Message - From: "Jeff Kilbride" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; "Andy C" [EMAIL PROTECTED] Sent: Wednesday, April 11, 2001 11:25 PM Subject: Re: Thanks: Re: Fed up to the back teeth with tomcat !!! Hi Andy, Did you ever post your configuration? I would be interested in what OS; Tomcat/Apache versions; JVM; DB backend and driver; whether or not you're I have to admit that the configuration is a little complex, mostly because of legacy database and servlets left over from the JavaWebserver version. Here goes though: Server is NT2000 Apache is 1.3.12 with mod_jk Tomcat is 3.2.2.b2 (I upgraded from 3.2.1 in the hope it would fix the problem.) JVM is 1.1.6 (old version but it's the only one that would run a legacy servlet) Databases are: mysql 3.23.28 (Handles all the main jsp stories) SQL server V7 (Handles servlet requests for release dates) JDBC bridge to mysql is mm-mysql-2.0.4 JDBC-ODBC bridge for SQL server (This could be the problem) Hope this is of interest. Andy C Editor R2 Project http://www.r2-dvd.org
RE: Thanks: Re: Fed up to the back teeth with tomcat !!!
There's a metric buttload of JDBC drivers out there, for every database: http://industry.java.sun.com/products/jdbc/drivers For MS SqlServer alone, they list 27; for ODBC, 19. -- Bill K. -Original Message- From: Jeff Kilbride [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 12:05 PM To: [EMAIL PROTECTED] Subject: Re: Thanks: Re: Fed up to the back teeth with tomcat !!! If I were to pick the weakest link, it'd probably be the jdbc-odbc bridge. FYI, for my own stress tests, I was able to run 24 hours at 20+ hits/second using Tomcat 3.2.1, IBMJava2-13, Apache 1.3.19, mod_jk w/ajp13, into a MySQL 3.23.35 database. This was all running on a fairly cheap linux box -- RedHat 6.2, 2.2.17 kernel, 128MB RAM, everything on one IDE drive. I was using a test suite with 25 concurrent threads on another machine (WinNT) connected by a 100bT ethernet doing simple insert statements. I actually got the Tomcat/Linux box up to 54 inserts per second, but the load average skyrocketed so I cut it back to something reasonable. Almost 2 million records into my database without a glitch. I was actually very surprised by the performance, since I hadn't tweaked anything and I was using the default Tomcat config. Granted, my test was pretty simple. I was only using one servlet and no .jsp pages. Are there any alternatives to the jdbc-odbc bridge? I thought that you used to be able to use the Sybase drivers to connect to MS-SQL -- but that may have been a long time ago and, obviously, nothing that was every officially supported. Thanks, --jeff - Original Message - From: "Andy C" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 12, 2001 12:22 AM Subject: Re: Thanks: Re: Fed up to the back teeth with tomcat !!! - Original Message - From: "Jeff Kilbride" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; "Andy C" [EMAIL PROTECTED] Sent: Wednesday, April 11, 2001 11:25 PM Subject: Re: Thanks: Re: Fed up to the back teeth with tomcat !!! Hi Andy, Did you ever post your configuration? I would be interested in what OS; Tomcat/Apache versions; JVM; DB backend and driver; whether or not you're I have to admit that the configuration is a little complex, mostly because of legacy database and servlets left over from the JavaWebserver version. Here goes though: Server is NT2000 Apache is 1.3.12 with mod_jk Tomcat is 3.2.2.b2 (I upgraded from 3.2.1 in the hope it would fix the problem.) JVM is 1.1.6 (old version but it's the only one that would run a legacy servlet) Databases are: mysql 3.23.28 (Handles all the main jsp stories) SQL server V7 (Handles servlet requests for release dates) JDBC bridge to mysql is mm-mysql-2.0.4 JDBC-ODBC bridge for SQL server (This could be the problem) Hope this is of interest. Andy C Editor R2 Project http://www.r2-dvd.org
Re: Thanks: Re: Fed up to the back teeth with tomcat !!!
Hi Andy, Did you ever post your configuration? I would be interested in what OS; Tomcat/Apache versions; JVM; DB backend and driver; whether or not you're using connection pooling and, if so, if it's a hand-rolled solution or a specific product; any settings you're passing the JVM on the command line (i.e. -mx, -ms, etc...); and anything else you can supply. I've heard good things about Resin as a servlet container, if you're looking for a commercial product -- http://www.caucho.com/ Thanks, --jeff - Original Message - From: "Andy C" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 11, 2001 2:22 PM Subject: Thanks: Re: Fed up to the back teeth with tomcat !!! Thanks to all for the advice, I'll be running though suggestions over the next couple of days and report back. Andy C