7 messages in com.mysql.lists.javaRE: JDBC Interface for Embedded Server ?
FromSent OnAttachments
Nigel Wetters06 Feb 2003 08:10 
Shankar Unni07 Feb 2003 13:50 
Peter Schäfer08 Feb 2003 06:24 
Mark Matthews09 Feb 2003 09:52 
Jonathan Baxter09 Feb 2003 12:51 
Mark Matthews10 Feb 2003 19:14 
Jonathan Baxter10 Feb 2003 19:45 
Subject:RE: JDBC Interface for Embedded Server ?
From:Shankar Unni (shan@cotagesoft.com)
Date:02/07/2003 01:50:15 PM
List:com.mysql.lists.java

Nigel Wetters writes:

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.

The main key is to stay out of the JNI *interface* as much as possible. JNI is fairly inefficient - the stepping between C and Java is a fairly heavyweight operation.

If it's possible to structure the driver such that lightweight calls (e.g. ResultSet.next(), ResultSet.get*(), etc.,) are all in pure Java, and you only go to C for the actual execute() or other calls that need to talk to the DB, you might be in good shape.

It'll be interesting to see what performance improvement you get..