Re: Basic Snapshot Question
Date: 1995/06/09
Message-ID: <3r9phh$mv7_at_fred.uswnvg.com>#1/1
Bob Reveal (msusrtp.bob_at_eds.com) wrote: : Does anyone know the procedures for having snapshots updated in intervals less than 1 minute (i.e. 1-10 seconds).
Very interesting! Have you ever thought of the number of hits to the database with the above scenario in addition to those done by applications and what it will do to your system's performance?
You might be better of giving direct access to the original database and spread the tables, indexes, etc across different disks to increase performance. If security is the issue, you can control it through roles and views. This would be much simpler than and achieve the same purpose as making sure your snapshots are updated every few seconds <shudder>.
PS: if you still insist on updating snapshots every few seconds, make sure
you have extremely fast machines with extremely fast disks and very wide bandwidth to push those data through.
Whatever I say and own are mine, mine and only mine! Kim Ng
Paradigm Computer Consulting, Inc.
U.S.A. Received on Fri Jun 09 1995 - 00:00:00 CEST