memory management - Does SQLite favour keeping indexes in its cache when possible? -

I am working in a memory constrained environment with SQLite 3.

I set the size of the Prague cache (say to say) 1 MB.

Let me assume that I have 2 MB of data, and 100 KB of index data

what SQLite indexes in its memory cache above and above data (except for 900Kb of data in the cache) )?

If not, how does the index reach from the perspective of management?

Thanks

No, indefinitely not in memory cache indefinitely Will be organized. If new data will be inserted, updated or deleted, sqlite3 can easily deplete less used data.

In fact, the indexes with memory management are very few: each INSERT or update , will rearrange sqlite3 data (depending on your system But on your HD or RAM). You can say simplified, that table has already ordered, when you are trying to access it. Compared to tables without indexing, there is no more memory required.