SQLite Forum

Recursively Import 10 GB sized csv file to sqlite fast without blocking reads
Login
Chronological Hierarchical 
DO the following:

```
PRAGMA journal_mode=WAL;
BEGIN;
DROP INDEX IF EXISTS idx;
DELETE FROM foo;
CREATE TABLE IF NOT EXISTS foo(ip TEXT, field1 TEXT, field2 TEXT, field3 TEXT, field4  TEXT, field5 TEXT, num1 REAL, num2 REAL, field6 TEXT);
VACUUM;
.mode csv
.import sample.csv foo
create index idx on foo(ip);
COMMIT;
```

Secondly, make sure you set a sufficient cache_size.