> -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Gesendet: Freitag, 1. Dezember 2006 18:06 > An: sqlite-users@sqlite.org > Betreff: Re: [sqlite] for what reason :memory: is much slower than > /dev/shm/dummy.db > > > John Stanton <[EMAIL PROTECTED]> wrote: > > > > I understand that Sqlite uses a less efficient algorithm > for :memory > > files than for the cacheing on regular files and that means lower > > performance on those memory DBs. > > > > 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? thanks in advance roland > > -- > D. Richard Hipp <[EMAIL PROTECTED]> > > > -------------------------------------------------------------- > --------------- > To unsubscribe, send email to [EMAIL PROTECTED] > -------------------------------------------------------------- > --------------- > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------