Subject Re: [ib-support] Firebird and SMP
Author Daniel Rail
Hi,

> Classic version misses the services API (backup/restore/etc...) and
> does not share a common buffer for connections to the same database.

There might be a services API for the Classic version of FB 1.5.
Someone is working on it, but I don't know if it's going to be ready
in time.

> Dependening on how much RAM and how many connections (other factors
> may apply) you will have on your system I think the performance of
> classic will be worse than SS attached to one processor.

When the number of users is small, then yes classic will not perform
as good as superserver. One thing to keep in mind, is that at the
moment, the performance of super server detiorates when the number of
concurrent users get higher(some reported around 200+). With classic
server, the performance is pretty much constant no matter what the
number of concurrent users. Definitely, the enhancement of the thread
scheduler(and tweakable via the configuration file) in SS helps when
having a lot of concurrent users.

Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)