15,091
edits
Changes
no edit summary
{{out man tip|The advice on this page was for older versions of date|Gramps so may not work for you. Please update as needed.}}{{stub}}<!--check accuracy}} / Incorporate "Import tested with the GRANDMA Mennonite database of 1.4 million people. by user on reddit!! https://www.reddit.com/r/gramps/comments/dzevcl/database_size_limit_for_gramps/fb6hdbj/ " -->
Large family tree data files, what to do, and what not to do.
==Loading the file==
The easiest way to do this is to:
# create a new Family Tree
# exit grampsGramps# add a '''<code>DB_CONFIG</code>''' file to the database directory before importing (see '''<code>gramps -l</code>''' output for the directory of a specific family tree. )
Contents of this DB_CONFIG file should be:
set_lk_max_locks 300000
set_lk_max_objects 300000
===SQLite backend===
Insert following line after the connect statement at line 103 in the [https://github.com/gramps-project/gramps/blob/maintenance/gramps52/gramps/plugins/db/dbapi/sqlite.py ''gramps/plugins/db/dbapi/sqlite.py''] file.
self.__connection.execute("PRAGMA cache_size = -50000")
A positive value sets the size in bytes. A negative value sets the size in pages. The size of a typical page is 4096 bytes.
The default value is -2000 which means 2000 pages of 4096 bytes each.
{{-}}
As there are many people, loading the person view might take some time. See a comparison of [[Gramps Performance|performance]] on large datasets, between different Gramps versions.
You can circumvent this load time by going to the [[Gramps_{{man version}}_Wiki_Manual_-_Categories#Relationships_Category|Relationships screenshot|relationships Category view]] before opening the family tree. This will open the active person and their family extremely fast, independent of the amount of data you gathered.
You can add bookmarks to common people, or in the branch you are researching. This allows to change person in the relationships view without the need to activate the person in the person view first.
== Avoid relationship calculation ==
Avoid displaying relationships on the status bar. From the {{man menu|Edit > Preferences}} ''Display'' tab change the '''Status bar''' option from {{man label|Relationship to the home person}} to {{man label|Active person's name and ID}}.
== Avoid Gramplets ==
Avoid gramplets which do a lot of database work. The '''[[Addon:Deep_Connections_Gramplet|Deep Connections]]''' Gramplet seems to be the worst case. These Those type of gramplets slow everything downenormously.
== Avoid general filters ==
For a surname search:
* click Click on a person in the [[Gramps_6.0_Wiki_Manual_-_Categories#People_Category|People screenshot|people Grouped Category view]]. Now start typing the family name of the person you need. The view will automatically go to the family name as you complete your typing.* for For a more detailed search, use the keyboard shortcut {{man key press|CTRL|F}}. This will expand all the nodes and allows to search more specifically.
== Flat views are faster than Tree views ==
Using a large family tree database and person treeview the People grouped tree view needs to often rebuild the view. especially after adding or deleting an object eg: Flat person view People (list) view is faster. == Avoid relationship calculation == Under the preferences dialog, go the to tab item, and select the option to display the {{man label|name}} on the status bar instead of the {{man label|relationship with the home person}}than grouped view.
=See also=
* [[Gramps Performance]]
* [[GEPS 016: Enhancing Gramps Processing Speed]]
[[Category:Documentation]]