Screenshot of results from KinshipList.sql in SQLiteSpy sorted on the RIN column. ![]() 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. SQLiteSpy 1.9.10 executed this script in 2 seconds! That’s a 145:1 improvement in speed. 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. This first script produces a table similar to the RootsMagic Kinship List report but it does so markedly faster for a large database. ![]() This page is intended to collect some scripts in support of calculating and displaying relationships between people in a RootsMagic database.
0 Comments
Leave a Reply. |