Re: reducing size database

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Tue, 24 Aug 1999 13:03:13 -0400
Message-ID: <7puji2$bq5$2@autumn.news.rcn.net>

Overall your performance should be better. When accessing the active section of the database you will get much faster retrieval times. When accessing the inactive segment your retrieval times will probably be two to four times as great (wild guess with some basis in fact) as when accessing the active part.

regards
Jerry Gitomer

Han Zijlstra wrote in message
<000b8d9b.15ba02c7_at_usw-ex0103-020.remarq.com>...
>Hello,
>W're developing a database with a huge amount of data in
>some of its tables (100-300 Gb).
>What is the impact on performance and maintability when the
>tables are splitted into two parts: a small but active
>part, containing 10% of the data and a large, but inactive
>part, containing 90% of the data?
>Almost all data is accessed by indexes.
>
>Thanks in advance,
>Han Zijlstra
>
>* Sent from RemarQ http://www.remarq.com The Internet's
Discussion Network *
>The fastest and easiest way to search and participate in
Usenet - Free!
>
Received on Tue Aug 24 1999 - 12:03:13 CDT