Hardware requirements question

From: Bastiaan Schaap <bschaap_at_desyde.nl>
Date: Tue, 10 Apr 2001 16:18:05 +0200
Message-ID: <tyEA6.13$ng6.688@psinet-eu-nl>

Hi all,

Currently I am working on a project to build a website that will gather statistics about intranet applications. We're trying to determine what kind of hardware we'll need. Because I've seen that some of you have experience with *huge* databases, I'd like to ask for your help.

Actually my question is very simple: we're estimating that in the database for this website, > 10,000,000 records a day will be inserted. After insertion of this data no mutations will be performed on this data, only calculations and selects. If it's possible we want to keep this data in the database as long as possible, with the minimum of a month. This means that about 3,000,000,000 records will exist within the database at all times. Which hardware/software platform should we choose to install our database on?

As with most simple questions, I don't know a simple answer.... I am *not* a DBA, and I think I have experience with too little platforms to make this kind of a decision. Performance is a great issue, since we need to calculate statistics out of this data on-the-fly.

Please share your thoughts with me,

Bastiaan

f u cn rd ths, u cn gt a gd jb n cmptr prgrmmng. Received on Tue Apr 10 2001 - 09:18:05 CDT