Re: Giant database - will it work

From: The Brew Witch <donal_at_brewich.com>
Date: Wed, 31 Aug 1994 01:57:17 GMT
Message-ID: <7LgwRc2w165w_at_brewich.com>


andrevw_at_ideta.nl (Andre van Winssen) writes:

>
> Imagine this:
>
> - your database will grow to 40Giga in two year's time
> - no updates , only daily inserts
> - there are predefined and ad hoc queries using a windows-client tool
> - a maximum of 20 concurrent connects to the database
> - software: SCO Unix, Oracle7.0 (7.1?)
> - hardware: Compaq/XL with 2 pentiums and 64M total memory

I would recommend using an optical drive for storage, and you will need to break the database into some smaller pieces. Perhaps 26 databases for records that start with A, B, C, etc... This will considerably improve the performance of any indivudual search and retrieve. Also, it removes certain problems with using very large index files.



Donal, SysAdmin of The Brewers' Witch BBS -- +1 713 272 7350 3 lines!
(Internet) donal_at_brewich.com  (@work) bill_at_sri.brewich.com  (CIS) 76460,1443
(SCA) Ld. Donal Dubh, IC of Dun Bruadair, B of The Stargate, K of Ansteorra
(Snail) 8880 Bellaire B-2 #139, Houston, TX  77036  (Anon UUCP) nuucp -
GCS/MU/T d+(---)p-c++(++++)lu+++e+/*m++_at_s+/++n---h--f?!g+w+++t+(+++)r++y++(*) ***Public Access Unix--Multichat, Internet mail, Usenet news, Games & more*** Received on Wed Aug 31 1994 - 03:57:17 CEST

Original text of this message