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, TimeOfSale, TicketGroup, Action,
HasBeenVerified, EPOSRecNo, CrossingName, QuantitySold) VALUES
('Terminal', 'HH098016', 'Test Company', '6992', 'Test Company',
'20140326-135946', '2014-03-26', '13:59:46', 'Test Company', 'Logout:
1#867.90$2#$3#$<Skpr=<DPu1=0<DPu2=0<DP1=419', 0, 0, '', 0)"
The import only does inserts, it doesn't do any other SQL-type
transaction during this sequence, and I use the same VB.net code as I
use for SQL Server (sorry to mention that here!), but SQL Server imports
the same data twice as fast.
Would having a field index or key help? I tried doing a Transaction
Commit, but it seems to fail after so many thousand inserts due to
'database being locked'.
I test it on my Windows 8 machine, but the database would have to be on
the customer's Windows 7 desktop or server.
Any suggestions welcome. Thank you.
Jonathan Trahair
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
