I am using SQLite as a backend as the speed/size is so much better. 400 Mbs down to 39 Mbs. Query time 14 seconds down to less than 1.
However what would be the best way to append data. Even though the tables are linked, a normal Append does not work, and a pass thru query does not work. Local...