Re: Hardware requirements question

Bastiaan

Please don't be offended, but for such a project, you would be well advised to get a professional DBA in at the design stage rather than trying to take it on yourself. With all the best advice in the world that you might get here, there will still be considerations not apparent unless your expert is sitting round the table included in the conversation. And at the end of the day, when you have collated advice from here and it still runs slowly, who are management going to blame? The NG, or you?

(As the other Andrew said however, partitioned tables/indexes etc will help greatly in the performance, but there are *so* many issues...)

Andrew

"Bastiaan Schaap" <bschaap_at_desyde.nl> wrote in message news:tyEA6.13$ng6.688_at_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 Wed Apr 11 2001 - 04:30:23 CDT