> Yes, a dumb of a system is provided daily
There are some great solutions already here for offline processing as stated in your question. However, something you might also want to consider (if you have requisite access to the system) is to use ‘after insert’ trigger(s) to online capture the change log into a table and dump that table along with other tables. This would be easiest and fastest solution while not needing any indexes to be added or queries to be optimized. - Neal > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
