Hey,

On 3/31/08, Robert Jordan <[EMAIL PROTECTED]> wrote:
>
> The runtime should be initialized once.


PL/Java creates a separate JVM process for
every stored procedure call. Using threads instead of processes would be
a more lightweight solution, but also removes the potentially better
robustness aspect of PostgreSQL (which is, in its turn, processed, so crash
of one connection won't make other connections crash).

Also, PL/Java uses a connection pool, so
previously created JVM process can be reused, what decreases the bad
performance factor.


Let's have a look at PL/Java's code: it comes with its own JDBC
> driver around Pg's SPI API. This probably means that there is no
> no way to pass a connection from inside a procedure to a driver.
> Same for PL/Perl.
>

Looks like you're right

-- 
Sincerely yours,
Olexandr Melnyk
http://omelnyk.net/
_______________________________________________
Mono-list maillist  -  [email protected]
http://lists.ximian.com/mailman/listinfo/mono-list

Reply via email to