[GENERAL] Storing Snapshot Data

Hi, all. I have a table which is continually updated with the latest totals. I would like to take snapshots of some of the data in that table and store it in a second table to run statistics on it later. What might some ways of doing this be? Illustrative (I hope) example using

Re: [GENERAL] Storing Snapshot Data

On Thursday 11 December 2003 12:42 am, John Gibson wrote: Hi, all. I have a table which is continually updated with the latest totals. I would like to take snapshots of some of the data in that table and store it in a second table to run statistics on it later. What might some ways of

Re: [GENERAL] Storing Snapshot Data

Hi John, John Gibson schrieb: Hi, all. I have a table which is continually updated with the latest totals. I would like to take snapshots of some of the data in that table and store it in a second table to run statistics on it later. What might some ways of doing this be? Illustrative (I

Re: [GENERAL] Storing Snapshot Data

John Gibson [EMAIL PROTECTED] writes: Unfortunately, I am stuck on how to get all three into the monitor table with the same timestamp. Do all the work in a single SERIALIZABLE transaction. That gives you a static, consistent view of the database for as long as you need.