Hi everyone, I’m currently working with a rather large Gramps database (about 20,000 individuals) on an old Windows laptop, using Gramps version 6.0. One issue I constantly face is the very slow search when I try to look up individuals by surname. It takes about 10 seconds for results to appear. S…

Try the experimental FullText search by @kku to see if it is better. He offered to try making it a Filter gramplet feature if people found it beneficial. But no feedback so far.

[image] UlrichDemlehner: Those blobs make it impossible to use the index capabilities This is not correct. Sqlite has the capability to create virtual columns using the function json_extract(). You can then build an index on the virtual column.

[image] csam: This is not correct. Sqlite has the capability to create virtual columns using the function json_extract(). You can then build an index on the virtual column. Right, but the blobs aren’t JSON objects. According to my understandig of the discussions, the idea (I’m not sure if it’…

We moved to using JSON objects instead of BLOBs in v6.0.

Ok, so I guess my understanding of what you told me here was wrong. Sorry for that and communicating my wrong understanding, but it appears that moving from Python blobs to JSON objects didn’t increase the speed of queries, quite the contrary. What would then be the reason for the (quite dramatic) p…

[image] emyoulation: He offered to try making it a Filter gramplet feature if people found it beneficial. But no feedback so far. The first feedback is here :wink: [image] Slow people and citations filter searches Help I think it would be great! @kku wh…

[image] Nick-Hall: We moved to using JSON objects instead of BLOBs in v6.0. As I understand, JSON objects give potential possibilities to make Gramps faster including search and filters. But JSON objects - its not enough. It needs some additional conceptual changes in Gramps core, more additi…

[image] UlrichDemlehner: but it appears that moving from Python blobs to JSON objects didn’t increase the speed of queries, quite the contrary. It’s true that switching from Python blobs to JSON hasn’t yet improved query speed—in fact, queries may even be slower for now. But this transition i…

Thank you all so much for your thoughtful and kind replies! :blue_heart: Many thanks to @emyoulation for explaining why the search in the right sidebar might be slow — it helped me understand things a bit better. [image] StoltHD: While it’s not a small, one-off change, converting to JSON is a …

When i search a Person by name, i use the People View, not grouped. I click on a line then i enter first letters. It’s very fast on my 13 years old notebook.

How to speed up individual search in Gramps 6.0 on older Windows laptop?

Help

Urchello July 26, 2025, 4:51pm 13

The first feedback is here

Topic		Replies	Views
Slow people and citations filter searches Help performance	37	591	July 26, 2025
Performance Issues with Gramps Development hacks , performance	77	1805	January 6, 2025
Understanding Gramps 6.0 Development roadmap	24	2440	January 20, 2025
Gramps, Next Generation Development design	26	728	January 3, 2026
Making Gramps filters Faster, and then Superfast Development performance	14	491	December 4, 2024

How to speed up individual search in Gramps 6.0 on older Windows laptop?

Related topics