SQLite Forum

slow import of CSV files
Login
This is the same thing with "Queen Elizabeth II" cruise ship sized cache.

```
>del sample.db
>sqlite sample.db
SQLite version 3.34.0 2020-09-26 18:58:45
Enter ".help" for usage hints.
sqlite> create table x(x text not null primary key);
sqlite> .timer on
sqlite> insert into x select random() from wholenumber where value between 1 and 10000000;
Run Time: real 21.598 user 20.265625 sys 0.984375
sqlite> ^Z
>del sample.db
>sqlite sample.db
SQLite version 3.34.0 2020-09-26 18:58:45
Enter ".help" for usage hints.
sqlite> create table x(x text not null primary key);
sqlite> .timer on
sqlite> insert into x select random() from wholenumber where value between 1 and 10000000 order by 1;
Run Time: real 20.600 user 19.046875 sys 1.171875
sqlite>
```