"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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
