[Mono-dev] Patch to improve ASP.NET SqlSessionHandler and correct "Prepare" leak problem

[Marek Habersack]

On Thu, 22 Nov 2007 12:33:20 +0100, Hubert FONGARNAND
<informatique.internet at fiducial.fr> scribbled:

Hello,

> Hi everybody,
>    
>    Last year, we have added Prepared Statement to the SqlSessionHandler
> (in order that bytea are send in a binary format for postgresql).
> There's a problem each time you do a Prepare, a plan is allocated to
> PostGreSQL... (in order to be reused later). In the current state,
> prepared statement are never reused and never "Deallocated" (prepared
> statement are deallocated when you close the connection)
>
> With this patch, the statement are prepared the first time and reused
> after. There's a big gain because the statement are compiled by the
> database and cached only once... There's no leaks too anymore!
>
> Please comment, review and commit (if it seems correct)
Committed in svn trunk, revision 90225, thanks!

regards,

marek
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 194 bytes
Desc: not available
Url : http://lists.ximian.com/pipermail/mono-devel-list/attachments/20071123/28c8d629/attachment.bin