Relative performance of Snapshots vs Replication

From: md_at_capita.nildram.co.uk (Martin ) <md_at_capita.nildram.co.uk>
Date: Thu, 12 Nov 1998 12:07:02 -0000
Message-ID: <24C3919081C7D011957F0800003843479488FC@ip3-99.nildram.co.uk>

We have a system residing in two machines, one for operational use and another one for enquiries and reporting. Some of the tables in the operational database will grow very big ( up to 64 million records after one year); we need to make these tables visible to the users of the enquiries/reporting database and are uncertain whether simple snapshots will be better than replication or even providing a read-only user onto the operational database.

Has anyone got experience of this particular issue?

Thanks in advance.

Toni Received on Thu Nov 12 1998 - 06:07:02 CST