Re: [sqlite] Sqlite3 delete action is too slow

Thank you MikeW. I try to use transaction, still slow. Use limit clause is good idea, but the help is limited. Dose number of index affect speed too? How many index on one table is better? Regards, Penny PennyH wrote: > > I create a DB and only one table in the DB. There are 3641043 r

Re: [sqlite] Sqlite3 delete action is too slow

My question is How can improve delete speed? This speed can not satisfy my application. Igor Tandetnik wrote: > > "yhuang" <[EMAIL PROTECTED]> > wrote in message news:[EMAIL PROTECTED] >> I create a DB and only one table in the DB. There are 3641043 records >> in the DB file. Min id is