Olexandr,

On 30-Mar-08, at 4:06 PM, Olexandr Melnyk wrote:

There are several potential problems I don't know how to solve yet.

First one is combining PostgreSQL's multi-process nature with Mono. Should Mono runtime be initialised every time a (Mono-based) stored procedure is invoked in PostgreSQL? How good will this work from performance stand point?

One runtime, likely per db instance the pl/mono hooks are installed in but we should look at how the isolation stuff works with java, but that being said see below.


Second one is handling transactions. If we want to allow sending queries back to the database from managed code, one way would be to create a connection in the opposite direction. However, this will not work with transactions as two connections are isolated from each other. Another possible solution is to pass connection resource from PostgreSQL through PL/Mono to managed code, and ask ADO.NET to reuse it. Any thoughts on this?


This is an implementation detail that can be considered as part of the summer process (research/suggestions). Today is the last day for applications so if you wish to be considered please make sure you get an application in today.

Thanks

-geoff

_______________________________________________
Mono-list maillist  -  [email protected]
http://lists.ximian.com/mailman/listinfo/mono-list

Reply via email to