Hi everybody.
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.
I think software logic, database dessign, are right (use of indexes, avoid plan NATURAL, periodical gbak and restore, etc...).

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?
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?
Maybe another item change could get better result (CPU, hard-disk, network) ?
Please tell me your experiences on this issue.
A lot of thanks in advance,

Hugo.


[Non-text portions of this message have been removed]