[Mono-list] GSoC Proposal: PL/Mono

Olexandr Melnyk omelnyk at gmail.com
Mon Mar 31 10:01:48 EDT 2008


On 3/31/08, Robert Jordan <robertj at gmx.net> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-list/attachments/20080331/f4de91b8/attachment.html 

More information about the Mono-list mailing list