On 10/17/07, Uma Krishnan <[EMAIL PROTECTED]> wrote: > Yes. Makes sense (not to cache query results for embedded apps). > So what is cached. Just dirty pages? or are raw tables cached when > queried?
SQLite implements a tables and indices as btrees over a pager layer. The pager layer caches pages. Various strategies are used to keep the page cache live as long as possible, including across transactions (if nobody modifies the database in between). Beyond that, most operating systems cache disk pages in memory. -scott ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
