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
_______________________________________________
Interest mailing list
Interest@qt-project.org
https://lists.qt-project.org/listinfo/interest
