Insert following line after the connect statement at line 103 in the gramps/plugins/db/dbapi/sqlite.py file.
self.__connection.execute("PRAGMA cache_size = -8000")
The default value is -2000 which means 2000 pages of 4096 bytes each.
2 Likes