This script produces a table similar to the RootsMagic Kinship List report but it does so markedly faster for a large database. RootsMagic 126.96.36.199 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.Screenshot of results from KinshipList.sql in SQLiteSpy sorted on the RIN column.
For more, see Relationships.