Re^5: Index a file with pack for fast access

[Anonymous Monk]

http://erictheturtle.blogspot.com/2009/05/fastest-bulk-import-into-sqlite.html

commands.txt

.echo ON

.read create_table_without_pk.sql

PRAGMA cache_size = 400000;
PRAGMA synchronous = OFF;
PRAGMA journal_mode = OFF;
PRAGMA locking_mode = EXCLUSIVE;
PRAGMA count_changes = OFF;
PRAGMA temp_store = MEMORY;
PRAGMA auto_vacuum = NONE;

.separator "\t"
.import a_tab_seprated_table.txt mytable

BEGIN;
.read add_indexes.sql
COMMIT;

.exit

sqlite3 mydb.db < commands.txt

[BrowserUk]

Cool! You found it. But try working it out for yourself from the SQLite docs.