I appreciate the encouragement I wanted to give an update. there are still some things that need to change but here was a snippet of the outcome of my first major test:
[22:52:26] Starting import…
XML Path:XXXXXXXXX\data.gramps
Database Path: XXXXXX\SQLite.db
[22:52:26] Import engine created, beginning import…
[22:53:45] ✓ XML Parsing: 15493831 records in 78.80s
[22:53:46] ✓ Database Setup: 0 records in 0.26s
[22:53:52] ✓ Places: 215180 records in 6.46s
[22:53:52] ✓ Sources: 8704 records in 0.26s
[23:02:43] ✓ Events: 12692533 records in 530.70s
[23:02:43] ✓ Notes: 9145 records in 0.24s
[23:02:43] ✓ Media: 0 records in 0.00s
[23:05:25] ✓ People: 1909594 records in 162.19s
[23:05:53] ✓ Families: 658675 records in 27.92s
[23:09:05] ✓ Associations: 10280414 records in 192.01s
=============================================================
IMPORT COMPLETE!
Import Complete: 15493831/15493831 successful, 0 failed, 1909594 people, 658675 families
Total Records: 15493831
Total Successful: 15493831
Total Failed: 0
Total Time: 00:16:39.119
I will be fixing things as I get further into it:
This is a huge difference from about 7 hours it initially took just importing XML using gramps to just over 16 minutes.