> 2. 50000 might be a bit too much, try 10000 pages.
> with 8k pages and 10000 buffers, SS will only use around 100MB of ram

Why only 10,000 pages? Doesn't FB2 remove the performance hit of having
a large cache? It was my plan to use 64K pages that are 16K large to
try to have most of the database reside in memory (well, at least 1GB).

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Stan
Sent: Thursday, August 03, 2006 2:11 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Firebird Server Config

1. Linux or Windows?
linux is faster.

2. 50000 might be a bit too much, try 10000 pages.

3. What page-size are you using? try 8K.

4. SS only uses 1 cpu, but has less overhead and shares the cache
between requests.

Classic uses all available CPUs, but does not share the cache
and has an overhead of starting a new process for each
connection.

note: with 8k pages and 10000 buffers, SS will only use around 100MB of
ram.

--- In firebird-support@yahoogroups.com, "thefourie2000" <cfourie@...>
wrote:

>
> Hi all...
>
> I'm trying to get a Firebird 2.0 RC 3 server configured for best
> performance. I'm using SS at the present. With default config file.
> My DB was restored with -bu 50000 (this sets the number of page
> buffers to 50000 right?) The DB is quite small @ 300MB.
>
> Anyway the server currently uses about 500MB memory as soon as I
> connect with a client. The client is starting up 5 threads, each with
> it's own DB connection.
>
> What can I do to improve performance? Should I use super or classic?
> Accept that I need to get more memory :) Or maybe just restore db with

> smaller buffer size?
>
> I've got a AMD 4200X2 that I'd like to use to the full :D
>
> Any and all help would be appriciated.
> Cronje
>

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item on the
main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links