Could be keep almost all the records so ~500000, but it varies greatly so sometimes will be just keep 10. I can adjust approach depending on size if necessary.
Yes the id1 are integer primary keys. Table1 has a number of indexes and views, so the create new table approach is less attractive _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users