Hi
I am using SQLite running under VB.net in a import routine of a series
of csv files, but it seems to be slow, and I don't mean microseconds, I
mean minutes.
A typical INSERT might be:
INSERT INTO AllSales (Source, MachineName, Location, UserPIN,
TariffName, CustomerID, DateOfSale,
On Apr 7, 2014, at 8:33 PM, J Trahair j.trah...@foreversoftware.co.uk wrote:
Any suggestions welcome. Thank you.
One word: transaction.
___
sqlite-users mailing list
sqlite-users@sqlite.org
On 7 Apr 2014, at 7:33pm, J Trahair j.trah...@foreversoftware.co.uk wrote:
Would having a field index or key help?
Adding more indexes and keys make searches faster, at the expense of making the
original INSERT slower.
As a test, instead of executing the INSERT commands, write the commands
On 2014/04/07 20:33, J Trahair wrote:
Hi
I am using SQLite running under VB.net in a import routine of a series of csv files, but it seems to be slow, and I don't mean
microseconds, I mean minutes.
A typical INSERT might be:
INSERT INTO AllSales (Source, MachineName, Location, UserPIN,
To: sqlite-users@sqlite.org
Subject: [sqlite] How to speed up a bulk import
Hi
I am using SQLite running under VB.net in a import routine of a series of csv
files, but it seems to be slow, and I don't mean microseconds, I mean minutes.
A typical INSERT might be:
INSERT INTO AllSales (Source, MachineName