Jump to content


Photo

A Fast Kinship List using SQLite

Kinship List Relationships SQLite

  • Please log in to reply
No replies to this topic

#1 TomH

TomH

    Advanced Member

  • Members
  • PipPipPip
  • 6268 posts

Posted 21 January 2016 - 03:05 PM

This script produces a table similar to the RootsMagic Kinship List report but it does so markedly faster for a large database. RootsMagic 7.0.11.0 took almost five minutes (290s) to calculate and display a 1900 page report for 75,000 people in a 160,000 population. SQLiteSpy 1.9.10 executed this script in 2 seconds! That's a 145:1 improvement in speed. Moreover, an SQLite manager can sort on the columns and filter the results (features vary depending on the product) and the SQLite Views created by the script can be exploited in further ad hoc queries the user may write.

KinshipList.PNG Screenshot of results from KinshipList.sql in SQLiteSpy sorted on the RIN column.

 

For more, see Relationships.


Tom user of RM7550 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com
SQLite_Tools_For_Roots_Magic_in_PR_Celti wiki, exploiting the database in special ways >>> RMtrix-tiny.png app, a bundle of RootsMagic utilities.