One additional note - my second experiment also used PRAGMA locking_mode=EXCLUSIVE;
I managed to drop that from the script somewhere along the line: /* First I tried some pragmas that looked promising */ PRAGMA journal_mode = OFF; PRAGMA legacy_file_format = OFF; PRAGMA page_size=32768; PRAGMA locking_mode=EXCLUSIVE; /* <<<<<<<< new line */ /* Create the tables: */ CREATE TABLE foo(left string, right string, group int, flags int); CREATE TABLE bar( left string, right string, group int ); /* Next, I tried adding an ascending key on group */ CREATE INDEX left_foo_dict on foo ( group asc, left ); CREATE INDEX right_foo_dict on foo ( group asc, right ); CREATE INDEX left_bar_dict on bar( group asc, left ); CREATE INDEX right_bar_dict on bar( group asc, right ); /* import the data */ .separator , .import foo.csv foo .import bar.csv bar total import time ~1hr. Phil _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
