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. :-(

sqlite-users mailing list

Reply via email to