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

Marek Habersack grendello at gmail.com
Fri Nov 23 10:04:08 EST 2007

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


> 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!


-------------- 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 

More information about the Mono-devel-list mailing list