Subject Re: [firebird-support] Hardware for the best Firebird performance
Author David Johnson
On Sun, 2006-07-16 at 09:52 +0000, jasajona wrote:
> Hello,
> What are most important things when choosing server hardware for
> Firebird? There will be big database (500mb) with tons of stored
> procedures that sometimes takes 10minutes to execute. There will be
> max ~5 simultanious connections.
500mb is practically empty. 500gb is big.

5 connections is no problem.

You could run this on a users desktop, although that would not be best.

10 minutes to do anything on this tiny of a database usually indicates
problems with the database schema or the process that is being run
against it, except for engineering simulation applications.

> I gues there should be 2 processors server. What to choose Intel or
> AMD. Dualcore or real two processor server? Processors cache, bus
> speed, CPU Hz? What type of rocessor is the best? What feature is
> important for memory? Do I need RAID, does it make sence if there will
> be enough RAM?

A machine is considered to be server class machine if it has 2 or more
processors, 2 or more GB Of RAM, and a fast bus.

> Do i need XP Server on it is enough XP Professional for SMP?

I'm a linux fan. It's cheaper and more reliable.