--- Renaud HUILLET <[EMAIL PROTECTED]> wrote: > I was surprised to see that sometimes the cache is not efficient.
SQLite uses a page cache, not a query cache. If you want a query cache, you have to program one yourself. Try testing against a memory database and/or with PRAGMA temp_store = memory; to see theoretical best-case timings. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------