[Interest] SQLite database: avoid high memory usage?

[Hamish Moffatt]

On 24/1/22 19:40, Alexander Dyagilev wrote:
> Hello,
>
> Let's suppose we have a database file of 16GB in size.
>
> We open it using this code:
>
> m_db = QSqlDatabase::addDatabase(
>              "QSQLITE",
>              dbConnectionName());
> m_db.setConnectOptions("PRAGMA jounal_mode=WAL;");
> m_db.setDatabaseName(m_dbPath);
> m_db.open();
>
> After this, our process will use 16GB of memory (at least, under 
> Windows OS). I.e. the whole database file is loaded into the memory.
>
> Is there a way to avoid this? 


Did you mean to misspell journal_mode?

Are you sure it's real memory usage and not just address space used by mmap?


Hamish