sub sk79, on Tuesday, January 14, 2020 10:54 AM, wrote... > > > 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. That is an idea I have not thought about, Neal. Thanks. The boss comes up with lots of requests, and these have to be done yesterday. I will have to look into triggers. Have not used them yet. :-(
josé <http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
