- Rebuild Indexes - forced a shutdown after more than 80 minutes
- Color coding - some 54000 individuals marked, 100 minutes to complete!
Meanwhile, there are a couple of workarounds to get to the same desired end result a lot faster:
- Don't! Do "Test database integrity" first. If it's okay, the SQLite database indexes are fine.
- If integrity is not OK, you will have to run RM's Rebuild Indexes for a while, having made a backup first, but you can interrupt it if you want after a few minutes using the Windows Task Manager (Ctrl-Alt-Delete) to stop RootsMagic. Restart RM on the database and go back to step 1.
- But your Birth and Death Years as shown in the sidebar Index and RootsMagic Explorer might not be in sync with the facts for some persons and you want to be sure they are (if multiple birth or death facts, it's the last one edited that normally sets the year). It is this process that consumed 98% of the time in the test case. Your choices are:
- let RootsMagic Rebuild Indexes all the way to the end; i.e., the slow way, OR
- use the SQLite queries Birth Year Mis-Match and Death Year Mismatch to find them and RM to edit the facts; even slower if there are many, OR
- use the SQLite script UpdateBirthDeathYears.sql described at Rebuild Indexes and Update Birth and Death Years; close and reopen RM to see the results.
- When RM reports x number of persons have been marked, it is safe to force RM to stop, using the Windows Task Manager. That said, you did make a backup first? Again, this part consumed about 2% of the time for the test database.
- When you reopen RM on the database, the new colors will be displayed; for the test case, that saved about 97% of the time it took RM to carry out color coding without interruption.