Slow people and citations filter searches

[Urchello]

That topic is already closed.

@Nick-Hall

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.

I tested it in on Ubuntu 22.04. The search time was decreased from 1.76 sec to 1.3 sec.