On 2/5/2013 7:54 AM, Jason Gauthier wrote:
time sqlite3 trip.db 'delete from trip where key<=1400'
real 0m1.532s
user 0m0.050s
sys 0m0.020s
-----------------------------------
The deletion takes 1.5 seconds. This is actually fast, it usually takes closer
2 seconds.
The difference between select and delete is that the former only reads
from the file, while the latter also writes to it. What kind of hardware
does your system have? Is there any reason why it may be unusually slow
writing to disk (or whatever device you are storing files on)? 1.5 sec
to delete 200 records does sound excessive (for a regular PC with
database file stored on a hard drive), even considering that three
indexes need to be updated.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users