I've run into a puzzling problem that still exists in 12.7. I have two tables in my database that can have thousands of records. For the first, even with 50K+ it opens quickly. But for the other, with 18K records it takes 1-2 minutes to open when this is executed: myDatabase.Open(myDB)
The table is created like this
dim s as String = "CREATE TABLE IF NOT EXISTS LinkTable(uuid String(36), parentUniqueID integer, childUniqueID integer, linkRelationship integer, comments text(128), dateAdded ullong, dateModified ullong, remoteSynced integer NOT NULL, changeTag varchar(2044), encodedCloudRecord blob(2048))"
Is there something I can do to improve this?