[image] Error using PostgreSQL as database backend with Gramps v5.2.2 what parts of Gramps suffer from performance issues that irritate you most as a user So Nick my input Statistics Number of Individuals 15365 Number of Families 4512 Number of Unique Surnames 2581 Individuals with med…

[image] Urchello: I had the same issue and my solution was move the note to a txt-file and attach it as a media. I dont know if this is possible but it really would be great give to the users ability disable all note-calculations and use it as a simple textarea. But maybe it is not possible beca…

I do all my research in Obsidian and/or Foam for VSC. Then I attach the markdown notes as media file to the Gramps object I am researching… That way I have a lot of features to help me in the research. Any Markdown or other notebook software that store notes in plain text files will do, in additi…

The large number of links is causing the problem. In v5.1, links in notes were only soft links, but in v5.2 we store them in a reference table. I think what we do is delete all the links for a note and then insert them back again. So when you edit your note it is probably doing 200 inserts. I’d …

[image] Nick-Hall: The large number of links is causing the problem. And also in my case I didn’t have links. It was transcribed audio. There was about 2-3 A4 pages of text I think. And I had the troubles not on saving but on letters typing/removing. The page was broken on each small change. …

[image] Obstipatus: I do all my research in Obsidian and/or Foam for VSC. Then I attach the markdown notes as media file to the Gramps object I am researching… That seems overkill for what I am currently doing. [image] Nick-Hall: The large number of links is causing the problem. In v5.1…

[image] Nick-Hall: Yes. SQL “Like” queries can only use the index up to the first wildcard. I don’t know anything about the design of RM and I haven’t used it myself so I can’t really comment on specifics. But, SQL can utilize Views in addition to indexes, so a query can be executed for that…

[image] Mihle: That seems overkill for what I am currently doing. By all means, you may not need this, but it was a tip on how you and others could get Gramps to work a bit faster and at the same time have good control over all your research notes and even expand the notes with graphic elemen…

[image] Obstipatus: while the Python scripts/filters running RegEx could query those subsets of data and run the RegEx filters and rules on that subset SQLite actually has a REGEXP operator that can be used in a similar way to LIKE.

[image] Nick-Hall: SQLite actually has a REGEXP operator that can be used in a similar way to LIKE. I was just thinking about not pushing too much into the database engine if at some point in time Gramps also would adapt to other types of database-backends.

Yes. We may wish to explore other types of database backends in the future. Some of the new hybrid models look interesting.

Performance Issues with Gramps

Development

Gioto November 18, 2024, 11:57pm 80

Some progress

Topic		Replies	Views
Slow people and citations filter searches Help performance	37	295	July 26, 2025
Improving performance in different areas Ideas	64	1249	July 2, 2022
Making Gramps filters Faster, and then Superfast Development performance	14	371	December 4, 2024
What are the slowest Features in Gramps Help performance	34	623	February 6, 2025
How to speed up individual search in Gramps 6.0 on older Windows laptop? Help performance	28	361	August 2, 2025

Performance Issues with Gramps

Related topics