searching java type 2 mysql driver (not JDBC is good too)
From: NOBODY (antispam_at_0.0.0.0)
Date: 10/08/04
- Next message: Dieter Bender: "Re: best way to store the results of a query?"
- Previous message: relaxedrob_at_optushome.com.au: "Re: Connection object as an instance or local variable?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Fri, 08 Oct 2004 02:37:26 GMT
I'm searching java type 2 mysql driver (not JDBC is good too).
or anything that will do JNI calls for
server-side prepared statement (ssps)
to a localhost mysql 4.1.5gamma db server.
Connector/j 3.1.4beta is not bad (ssps are 400% faster than client-side PS
on long inserts/updates (ex: 200 fields)), but still not a type 2 driver.
Raw Socket writes (ssps type 4) are still ~3 times slower than passing
through jni (some corse benchmarks seen).
Imagine if you had JNI-enabled ssps: you would be about 12x faster...
Note: already tried java2mysql 0.3 on sourceforge. Don't suggest it.
(Not good. No better than 3.0.9 client-side prepared statements (1x).)
Thanks for suggestions.
- Next message: Dieter Bender: "Re: best way to store the results of a query?"
- Previous message: relaxedrob_at_optushome.com.au: "Re: Connection object as an instance or local variable?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]