Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: High-Speed/Volume Database

Re: High-Speed/Volume Database

From: Adrian Carlson-Hedges <adrian.ch_at_btinternet.com>
Date: Mon, 6 May 2002 19:38:55 +0000 (UTC)
Message-ID: <ab6m4f$9ao$1@helle.btinternet.com>


Partitioning.

Range based if your adds/deletes are time dependant. (i.e. you want a 2 week moving window of data.) You can then if necessary subpartition.

Adrian

"Bob Smith" <gatesucks_at_hotmail.com> wrote in message news:b87ff855.0205060836.198e5013_at_posting.google.com...
> We are designing an application that needs to use
> a relational database to hold quite a large amount
> of data.
>
> In particular there is one table that has about 33
> fields, 18 indexes, and 120 bytes per record.
> Additionally, we are going to need to add about 2
> million records per day to the table, delete about 2
> million records per day from the table, hold 2 weeks
> worth of data within the database (approx. 30 million
> records), and sustain an average add rate of about 23
> records per second while, at the same time, sustaining
> an average delete rate of 23 records per second.
>
> My questions are, what database software should we use,
> what kind of hardware platform will be needed to
> support the specifications enumerated above, and what
> kind of average query performance can we expect?
Received on Mon May 06 2002 - 14:38:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US