RE: JDBC Interface for Embedded Server ?

[Peter Schäfer]

> -----Ursprüngliche Nachricht-----
> Von: Nigel Wetters [mailto:nigel@stripped]
> Gesendet: Donnerstag, 6. Februar 2003 17:11
> An: java@stripped
> Betreff: Re: JDBC Interface for Embedded Server ?
>
>
> sorry for delurking two weeks' late, but I only just realized I'd been
> mentioned.
>
> S2> Nigel Wetters also attempted to do the same thing, and we were
> S2> exchanging some ideas and even started a Sourceforge project
> S2> (http://sourceforge.net/projects/java2mysql)
>
> yes. bit of fun really, but I sorta thought (and stated quite arrogantly
> on this list) that it would be much faster than mark's type IV driver. I
> was mostly wrong. After I'd introduced the necessary synchronization,
> the type II driver was the same speed as the type IV driver. I sorta
> lost interest at that point.
>
> slarty2 probably had the right idea when he suggested that to be any
> faster, a lot of the driver should be written in C, whereas my efforts
> were a very thin layer of C with a thick layer of java.
>

If I understand you correctly, your driver is connecting to an external
MySQL server.
So you still have the network traffic plus the JNI overhead.

My idea was to use libmysql and run the server from the Java application.
That would eliminate the network traffic.
The tricky thing is to get the server process started. I played around a bit
but didn't get very far.