Yes, Processing at 100%. Windows 2000server. Not sure of the
mainboard model. SATA from the board.

I was thinking of recommending our client get something like a Dell
PowerEdge server with;

* 2 or 4 Xenon 3.6Mhz CPU's - but I'm not sure more than 1 CPU with
make much of a difference with Firebird 1.5?

* 2-8Gb ECC RAM - but I'm not sure how much more RAM firebird 1.5 can
benefit from?

* 3-5 SCSI drives (RAID 0) - I was also thinking of having OS and
TEMP on a separate RAID channel to the DB. Also when running RAID 0
would 5 drives be faster than 2?

I am basically looking for a machine than will be approximately 30-40
times faster than a AMD3000+ SATA RAID5 machine with 50GB database.

Note Also; firebird.conf has all defaults.
PageSize=8192. Buffers=65535


--- In firebird-support@yahoogroups.com, "Roberto Novakosky"
<rnovak@i...> wrote:

> When the system is running to recalculate, is your processor at

100% ?

> Give more detail about the main board too, what the model.
> And is it running on Win 2000, or other O.S. ?
> Are they using interfaces SATA from main board or from a controler

board PCI ?

>
>
> Roberto Novakosky
> ----- Original Message -----
> From: ak_s13
> To: firebird-support@yahoogroups.com
> Sent: Tuesday, March 15, 2005 10:41 PM
> Subject: [firebird-support] Hardware recommendations
>
>
>
>
> We using firebird for a multi-store retail reporting application.
>
> One of our clients is running a system with PC hardware;
> AMD 3000+, 2Gig RAM, SATA RAID5.
>
> We have a proccess that re-calculates consolidated report totals
> based on new department structure changes. This is taking over a

week

> to complete on their database (approx. 50Gb).
>
> My question;
> What hardware would could you recommend to allow this process to
> complete in 4-6hours?
>
>
> Thanks in Advance.
>
> [Non-text portions of this message have been removed]