Re: [sqlite] how to speed up da insertion?

[Jay Sprenkle]

On 5/9/06, Will <[EMAIL PROTECTED]> wrote:

I insert like followings :

rc = sqlite3_prepare(m_pDB, szSQL, -1, &pStmt, 0);
sqlite3_bind_int64(pStmt, 1, m_pTBDataDBData->lTime);
...

rc = sqlite3_step(pStmt);

rc =sqlite3_finalize(pStmt);

Putting your insert statements inside a transaction will speed them up
a lot:

begin transaction;
insert into mytable values( '10:30 2004/04/01');
insert into mytable values( '10:31 2004/04/01');
insert into mytable values( '10:32 2004/04/01');
insert into mytable values( '10:33 2004/04/01');
commit;


A large number of indexes on the tables can also slow down inserts.