AW: RE: RE: [sqlite] How long can I keep a prepared statement around?

2006-09-25 Thread michael . ruck
That's basically the way I do it. I have a factory method for all prepared statements, where I wrap the (optional) recompilation in and aquire a named mutex for every method invocation in the class. I think this should be a safe approach to prevent SQLITE_SCHEMA errors if the only schema

RE: RE: [sqlite] How long can I keep a prepared statement around?

2006-09-25 Thread Shields, Daniel
> Looking at the implementation of sqlite3_expired, its just a > comparison of the expired flag in the statement or if the > passed statement is NULL. The cost is an additional if > statement before execution, however this does not save you > from SQLITE_SCHEMA errors. In theory someone could