On 16 Jan 2002, at 8:18, ibfa2000 wrote:

> One more question: for my purpouse (Firebird running on an embedded
> Linux, small db (<20Mb), few concurrent access (2 to 10), would you
> choose Classic or SuperServer?

Depends on the memory constraints, TPS you want and access
characteristics. The database size is mostly irrelevant. I'd try to go
with Classic, but it depends :-) Some rules for decision:

1) If users has different or random data access patterns, then you
would not gain much from shared cache in SuperServer. It's difficult
to measure off-hand, as it depends on many values (db size, cache
size, page size, access characteristics, concurrency etc.)

2) If you have tight memory constraints (less than usercount * 2-
3MB), then SuperServer would be better.

3) Classic is often (depends on HW and OS) more efficient in
concurrent disk I/O (better throughput).

HTH

Pavel Cisar
http://www.ibphoenix.com
For all your upto date Firebird and
InterBase information