Difference between revisions of "Tips for large databases"

From Gramps
Jump to: navigation, search
(conversion of TipsForLargeDatabases)
 
(copyedit, wikilinks and image)
Line 1: Line 1:
Large data files, what to do, and what not
+
Large data files, what to do, and what not to do.
[[Category:Documentation]]
 
 
 
  
 
==Loading the file==
 
==Loading the file==
 
+
[[Image:EditPreferencesGeneral226.png|thumb|General tab of Edit->Preferences dialog box]]
 
 
 
For small files, you can work on GEDCOM or GRAMPS XML format. This works great.
 
For small files, you can work on GEDCOM or GRAMPS XML format. This works great.
However, these formats are completely in you computer memory, so for larger files, they become slow, and might bring your computer to a standstill.
+
However, these formats are completely loaded in your computer memory so, for larger files, this becomes slow and might bring your computer to a standstill.
 
 
Therefore, you should only handle large files by the GRAMPS GRDB format. You do this by creating a new GRDB file, and importing the large file into it. This can take a long time! Do it in the evenings. If you enable transactions in menu Edit->Preferences, the importing of data will be much faster
 
  
 +
Therefore, you should only handle large files by using the GRAMPS GRDB format. You do this by creating a new GRDB file and importing the large file into it. This can take a long time, so do it in the evenings! If you '''enable database transactions''' in the  Edit->Preferences->General menu tab, the importing of data will then be much faster.
 +
<br clear="all">
  
 
== Default view: bookmarks and active person ==
 
== Default view: bookmarks and active person ==
 +
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 [[Relationships screenshot|relationships view]] before opening the grdb file. This will open the active person and their family extremely fast, independent of the amount of data you gathered.
As there are many people, loading the person view might take some time. See the performace results: [[GRAMPS Performance]].
 
 
 
 
 
You can circumvent this load time, by going to the relationships view before opening the grdb file. This will open the active person and his 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.
 
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 general filters ==
 
== Avoid general filters ==
 
+
Filters search all the data looking for the people who satisfy your query. Try to avoid this on large files.
 
 
Filters go over all the data looking for the people who satisfy your query. Try to avoid this on large files.
 
  
 
For name searches do the following:
 
For name searches do the following:
* click in the person view on a person. Now start typing the family name of the person you need. The view will automatically go to the family name
+
* click on a person in the [[People screenshot|people 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 more detailed search, click ''CTRL-F'' first. This will expand all nodes and allows to search more specifically.
+
* for a more detailed search, click ''CTRL-F'' first. This will expand all the nodes and allows to search more specifically.
 
 
  
 
== Please contribute ==
 
== Please contribute ==
 +
If you have more tips for working with large databases, please share them here.
  
If you more tips for large databases, please share them
+
[[Category:Documentation]]

Revision as of 09:13, 6 March 2007

Large data files, what to do, and what not to do.

Loading the file

General tab of Edit->Preferences dialog box

For small files, you can work on GEDCOM or GRAMPS XML format. This works great. However, these formats are completely loaded in your computer memory so, for larger files, this becomes slow and might bring your computer to a standstill.

Therefore, you should only handle large files by using the GRAMPS GRDB format. You do this by creating a new GRDB file and importing the large file into it. This can take a long time, so do it in the evenings! If you enable database transactions in the Edit->Preferences->General menu tab, the importing of data will then be much faster.

Default view: bookmarks and active person

As there are many people, loading the person view might take some time. See a comparison of performance on large datasets, between different GRAMPS versions.

You can circumvent this load time by going to the relationships view before opening the grdb file. 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 general filters

Filters search all the data looking for the people who satisfy your query. Try to avoid this on large files.

For name searches do the following:

  • click on a person in the people 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 a more detailed search, click CTRL-F first. This will expand all the nodes and allows to search more specifically.

Please contribute

If you have more tips for working with large databases, please share them here.