Re: MySQL Gets Functions in Java - Enlightenment Please

Robert Treat <xzilla@users.sourceforge.net> writes:
> On Sat, 2003-12-20 at 13:04, Dave Cramer wrote:
>> Is it more desirable to have a single java vm and communicate via RPC,
>> or some other mechanism?

> If you fire up the jvm at connection creation time rather than at first
> pljava function call, wouldn't that make things much simpler and faster
> per process?

You could possibly support both approaches by using the "library preload"
mechanism that Joe Conway developed recently.  That is, the DBA can
either:

* Preload pljava, whereupon a JVM is created by the postmaster, and the
connection to this JVM is passed down to each backend and shared by
them.

* Do nothing, whereupon each backend that actually makes any pljava
function calls would have to start a JVM upon its first call.

I could see either of these approaches being the more efficient,
depending on how much pljava work is done in a given installation.
So being able to support both seems attractive.

            regards, tom lane