Hi Robert !
Robert martin wrote:

>Thanks for the quick response Alexandre.
>
>

It's a pleasure ! :-)

>
>
>>Page buffers are too small, are you using classic ou super server ?
>>
>>
>>
>>
>I hadn't paid much attention to the Page buffers (I just looked it up in
>the Firebird Book!). The setting I have comes from a component I use (I
>think). We are using super server, The DB is about 300MB, 12 users, and
>the machine running it has plenty of RAM (more than Igig I believe).
>
>What do you recommend?
>
>

Page Size 8196 and 1000 page buffers

This will lead you to have 80MB of data in FB cache, for a 300MB
database will be reasonable.

The SO cache could help too since you have a lot of RAM, and the FB
server will use the RAM to make in memory sorts too, what it is already
doing.

If you use SS the number of concurrent users doesn't matter for the
cache size, since the cache are shared among the connections, if you use
CS each connections has a distinct cache, taking the above example for
classic you lead you to 960MB (12 * 80MB) of RAM just for the cache, in
case you use CS I recomend to keep the cache a bit small (half of what I
suggested for SS) for each connection.

>
>Rob Martin
>Software Engineer
>
>phone +64 03 377 0495
>fax +64 03 377 0496
>web www.chreos.com
>
>Wild Software Ltd
>
>

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.1 - Release Date: 23/03/2005