On Wed, Mar 14, 2001 at 11:08:48AM -0800, Orion Henry wrote:
> * Since most of what I am doing is inserts I will assume that the disk
> will be my bottleneck over anything else. Is this correct?
Recent personal experience has sold me on hardware RAID controllers
and lots of RAM. Dell's relative
Have you done any benchmarks with a prototype of your application.
Based off of some of the numbers I've been seeing with my testing,
I would not be surprised if a single pIII 1ghz box with a decent disk
(ata 100 or scsi 160) would handle the load you describe and is way
cheaper than some big smp
On 3/14/01, 7:08:48 PM, Orion Henry <[EMAIL PROTECTED]> wrote
regarding [GENERAL] Fast Inserts and Hardware Questions:
Please bear in mind that you are operating well above anything I do, so
I'm not speaking from experience.
> I am specing out a database for my company and I need some advice.
Orion Henry writes:
> The indexes will be
> int8 (primary key)
> int4 (group number)
> timestamp (creation date)
> int4 (customer id)
Since one query can only use one index per table, you should only need the
customer_id index, given the queries you listed.
> * Is there an OS that is best suite
