[EMAIL PROTECTED] wrote: > > > > It uses exactly the same algorithm. It is just that the hash > > tables are fixed sized and are designed for a cache, not for > > an entire database. > > Does this mean, that if i use :memory: databases, the cache-layer of = > sqlite > is disabled? >
No. It means the cache is the whole in-memory database, rather than just a cache of the most recently accessed pages of the disk database. When you specify a file named ":memory:" about all that happens is that write-to-disk is disabled. Everything that would have been written to disk stays permanently in cache. Thus it becomes an in-memory database. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
