}
}
}
---END---
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of J Trahair
Sent: Monday, April 07, 2014 2:33 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] How to speed up a bulk import
Hi
I am using SQLite running under V
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, Tari
On 7 Apr 2014, at 7:33pm, J Trahair 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
themselves to a text file. The
On Apr 7, 2014, at 8:33 PM, J Trahair wrote:
> Any suggestions welcome. Thank you.
One word: transaction.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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, TimeOf
5 matches
Mail list logo
