Summary of slow down issues

[emyoulation]

Just for completeness, Nick noted that a reason BSDDB could be faster with large trees is because SQLite has a smaller cache.

Could/should the cache be made adaptive to the Tree size?

Performance Issues with Gramps

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.

And there’s an outstanding addition for the wiki article:

@Nick-Hall

We also have a Tips for large databases page which need updating for the SQLite backend. I’ll add a section for increasing the cache size.