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

We are using this for all commands because developer are lazy. Together with explicit prepare, no possible performance loss, just memory. But I'm not sure for commands without prepare. If I remember API, there is possibility to execute SQL without prepare. And in this case, the first time will be

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

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 wrote: > Hi all, > > after discussion with Jiri

[Firebird-net-provider] [FB-Tracker] Created: (DNET-748) Improve input buffer

Improve input buffer Key: DNET-748 URL: http://tracker.firebirdsql.org/browse/DNET-748 Project: .NET Data provider Issue Type: Improvement Components: ADO.NET Provider Affects Versions: 5.8.0.0

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

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.