[Interest] SQLite database: avoid high memory usage?
Hamish Moffatt
hamish at risingsoftware.com
Mon Jan 24 10:39:56 CET 2022
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
More information about the Interest
mailing list