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
>
>
