Re: [sqlite] Implementing a statement cache

2019-12-21 Thread Roger Binns
On 16/12/2019 13:38, carsten.muencheberg wrote: > I am working on a generic cache for prepared statements I really wish SQLite had a statement cache behind the scenes, so that devs don't have to keep re-implementing a statement cache. I would be delighted to delete the statement cache code in AP

Re: [sqlite] Implementing a statement cache

2019-12-17 Thread E.Pasma
> Op 16 dec. 2019, om 22:38 heeft carsten.muencheberg > het volgende geschreven: > > Hi, > I am working on a generic cache for prepared statements and would like to > make sure that I am not overlooking anything important. > > The cache is a simple map from an SQL string to a statement pointer

[sqlite] Implementing a statement cache

2019-12-16 Thread carsten.muencheberg
Hi, I am working on a generic cache for prepared statements and would like to make sure that I am not overlooking anything important. The cache is a simple map from an SQL string to a statement pointer. 1. When to call sqlite3_reset()? It looks like the safest and easiest approach is to call