chetana bhargav uttered:
Hi,
I have a question regrading indexes,
When I open a connection,
Will indexes be loaded into memory. If one of the tables in the DB, the
connection for which I have opened, has an index.
If, so is there any way to selectively load/unload that from memory.
Indexes will be loaded into the cache as needed. The whole SQLite database
is page based, and the cache caches the pages. The tables and indexes are
implemented as page based btrees, with nodes represented by pages.
The cache is unaware of the higher level structure of the btrees, and
there is no way to selectively bring load/unload tables or indexes from
memory. The page cache will manage itself on an LRU basis.
...
Chetana.
Christian
--
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
