--- In firebird-support@yahoogroups.com, "Rick Debay" <rdebay@...> wrote:

>
> > 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).

I have read that having a larger (more than 10000 page) cache actually
hurts performance. I am not sure whether this is true for 2.0

-stan

>
> -----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
>