mORMot Open Source

richardmaley

Member

Registered: 2012-11-05

Posts: 4

Fastest Import of tab delimited data into Sqlite3 Table

Having analyzed the tab delimited data and created an appropriate Sqlite3 table what is the fastest way of populating the table?

I have been looping through the creation of insert statements, however it is slow.

What is the fastest.

Thank you.

Richard Maley

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Fastest Import of tab delimited data into Sqlite3 Table

See http://synopse.info/forum/viewtopic.php?id=910

In short:

1) Use a transaction;
2) Use a prepared INSERT statement with ? parameters;
3) Set DB.Synchronous := smOff

All those are standard SQLite3 expectations.
See http://stackoverflow.com/questions/1711 … -of-sqlite