[nhibernate-issues] [JIRA] Updated: (NH-519) Cache and reuse prepared statements

[NHibernate J. <mik...@us...>]

     [ http://jira.nhibernate.org/browse/NH-519?page=all ]

Sergey Koshcheyev updated NH-519:
---------------------------------

    Fix Version: LATER

> Cache and reuse prepared statements
> -----------------------------------
>
>          Key: NH-519
>          URL: http://jira.nhibernate.org/browse/NH-519
>      Project: NHibernate
>         Type: Improvement
>   Components: Core
>     Versions: 1.0.1
>     Reporter: Geert Verbakel
>     Priority: Minor
>      Fix For: LATER
>  Attachments: prepared statements.txt
>
> Same bug as NH-140 (reintroduced in 1.0.1.0)
> The same statement (for eagerly loading many-to-one objects) is prepared everytime it is executed.
> In 0.6.0.0, a statement would be prepared once and reused:
> * declare @P1 int
>   set @P1=443
>   exec sp_prepexec @P1 output, N'@p0 uniqueidentifier', N'SELECT ..... WHERE Id= @p0', @p0 = '611475FC-FC66-4C3A-8C2D-0BB27AF8BDCA'
> * exec sp_execute 443, @p0 = '23BBE372-74E7-4EFB-B605-9DDA90E02462'
>   (multiple times)
> In 1.0.1.0, this is no longer the case. It is always sp_prepexec
> I have set hibernate.prepare_sql to true, which result in statements being prepared, but not cached...
> See attached file for Query analyzer details

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira