Hi Hugo,

> I have a multi-user application (developed with C++Builder5 and IBO4)

running on a local network at 100Mb.

> There are 30 workstations with Win2000 Professional; the CPUs are about

PIII 850 Mhz , 128Mb RAM

> There is a server with Firebird 1.0, Win2000 Server; it's a double

processor PentiumIV 1400 Mhz, 512Mb RAM, Ultra Wide SCSI III 18Gb hd for
the databases.

Did you pin the Firebird process down to a single server?

> I think software logic, database dessign, are right (use of indexes, avoid

plan NATURAL, periodical gbak and restore, etc...).

A periodical "restore" should not be needed, IMHO.

> How could I increase global performance, only making hardware changes (on

the server, I assume)?

> Could it be the best option to put more RAM memory?

I bet it doesn't even use 512Mb now - how much page-buffers is your database
using?

> If so, how can I calculate the optimum need, based on number of concurrent

users?

> Currently, cache configuration for the Firebird Server is default. How can

I adjust this value, to tuning with RAM amount of memory?

Either use gfix or your favourite GUI tool ( I know one :)

> Maybe another item change could get better result (CPU, hard-disk,

network) ?

Disks are important - you will gain speed if you use a RAID controller with
multiple
disks.

You are also selecting small resultsets to transfer across the network?


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."