Re: Help with connection pooling the *right* way...

On Wednesday 03 April 2002 05:18 pm, Victor van Dijk wrote:
> Hi,
>
> It seems to be Ok. But you can also use the caucho MySQL driver. It
> is supposed to be faster than the mm.mysql driver. The caucho
> driver is already included when you install 2.0.5 .
> Take a look at http://www.caucho.com/projects/jdbc-mysql/ for more
> details.

In case anyone's interested in the results: I've just been playing
with Siege, a simple, open-source command-line load testing program
<http://www.joedog.org>. I thought I'd see what my webapp will do
with the different MySQL drivers and Apache/mod_caucho. I set up a
testcase with 40 concurrent users, each executing 100 searches.

With mm.mysql, the best I can do is about 28 searches/second, and
only if I use Apache. For some reason it always crashes after about
2500 hits when querying port 8080 directly. OTOH, I've gotten as high
as 36 searches/second with the Caucho driver. It seems to be slightly
less stable when using mod_caucho (which makes sense), but the speed
is comparable either way.

I'm running Redhat 7.1 on an Athlon 1200/1.5G ram, with JDK 1.4 in
client mode. Can't even get 100 hits in server mode. Go figure.

Steve
Received on Thu 04 Apr 2002 19:23:08 -0800