Angus March wrote: > I have a table where I need to record the date of each insert. > Sometime later I'll then delete all rows that were inserted more than > 90 days ago. Is it possible to do this w/out performing a table scan?
Create an index on the date column. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users