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 27081364, Max id is 30902585. >> >> I did follow operation: >> >> sqlite> delete from XXX where userId>30900000 and userId<30902000; >> >> took 1'32'' >> >> >> >> sqlite> delete from XXX where userId>29000000 and userId<29902000; >> >> spent 3 hours and 33minutes and 26secs > > If your question is about why the second statment takes so much longer > than the first, it's because it deletes 902,000 records vs 2,000 for the > first. Did you perhaps mean to write userId>29900000? > > Igor Tandetnik > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/Sqlite3-delete-action-is-too-slow-tp20163980p20181076.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
