Re: [Firebird-net-provider] Prepared statements cache inside .NET provider

[Gerdus v. Z. <ger...@gm...>]

Sound interesting to have in the provider.

Is this only for commands that has Prepare() explicitly called on?
Is there a scenario where performance will be slower than currently?

On 29 March 2017 at 11:58, Slavomir Skopalik <sko...@el...> wrote:

> Hi all,
>
> after discussion with Jiri Cincura I prepare proposal for prepared
> statement cache that will be implemented inside .NET provider.
>
> Motivation:
>
> Preparation of SQL statement take a time and also server resources. Many
> SQL server has this functionality build in in engine, but FB not.
>
> More reading for example here:
> http://stackoverflow.com/questions/12141036/preparedstatement-caching-
> what-does-it-mean-how-does-it-work
>
> We implement this to speed up our web application (cache is persistent
> across web requests).
>
>
> Ideas:
>
> Each connection that already exists in pool well keep a private
> dictionary of cached statements (can be disable by config).
>
> Not used SQL will be released after some time out, also cache will have
> maximum statements like default 100.
>
> When application obtaining new connection from pool, provider will look
> for free connection with higher number of cached statements.
>
>
> The question:
>
> Is this interesting to have this functionality inside provider and fully
> transparent?
>
> Slavek
>
> PS: We combine this with RO transaction pool and also with data caching,
> but this is different story.
>
>
> --
> Ing. Slavomir Skopalik
> Executive Head
> Elekt Labs s.r.o.
> Collection and evaluation of data from machines and laboratories
> by means of system MASA (http://www.elektlabs.cz/m2demo)
> -----------------------------------------------------------------
> Address:
> Elekt Labs s.r.o.
> Chaloupky 158
> 783 72 Velky Tynec
> Czech Republic
> ---------------------------------------------------------------
> Mobile: +420 724 207 851
> icq:199 118 333
> skype:skopaliks
> e-mail:sko...@el...
> http://www.elektlabs.cz
>
>
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>



-- 
------------------------------------------------------------------------
Gerdus van Zyl
www.infireal.com