Re: [sqlite] Using Bulk Insert in SQLite

2011-01-10 Thread Simon Slavin
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 ...

[sqlite] Using Bulk Insert in SQLite

2011-01-10 Thread Sunil Bhardwaj
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

Re: [sqlite] Using Bulk Insert in SQLite

2011-01-10 Thread Alok Singh
*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

Re: [sqlite] Using Bulk Insert in SQLite

2011-01-10 Thread Tito Ciuro
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

[sqlite] Using Bulk Insert in SQLite

2011-01-10 Thread Sunil Bhardwaj
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