On 10 Jan 2011, at 1:10pm, Sunil Bhardwaj wrote:
> We have large number of records in memory and we are using SQLite in-memory
> using C++.
>
> How can we use Bulk Insert to speed up the record insertion process in SQLite
> in one transaction.
CREATE TABLE ...
BEGIN TRANSACTION
INSERT ...
Hi
We have large number of records in memory and we are using SQLite in-memory
using C++.
How can we use Bulk Insert to speed up the record insertion process in SQLite
in one transaction.
Please suggest.
Thanks
Sunil Bhardwaj
Ext. 1125 (0120-2567001)
9818868910
*here are summary code :inserting 100k in 5-7 sec*
*
*
//Reading text file 1 in
yarray2= filetext.Split(Environment.NewLine)
//Reading text file 1 in
yarray1 = filetext1.Split(Environment.NewLine)
insert:
Dim tx = cons.BeginTransaction()
For y = j To x
Dim
Sunil,
Google is your friend:
http://www.google.com/search?client=safari=en=bulk+insert+sqlite=UTF-8=UTF-8
Regards,
-- Tito
On Jan 10, 2011, at 11:25 AM, Sunil Bhardwaj wrote:
> Hi
>
> Please suggest, how can we implement Bulk Insert in SQLite.
>
> Thanks
> Sunil Bhardwaj
> Ext. 1125
Hi
Please suggest, how can we implement Bulk Insert in SQLite.
Thanks
Sunil Bhardwaj
Ext. 1125 (0120-2567001)
9818868910
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
5 matches
Mail list logo