Subject | Firebird Server Config |
---|---|
Author | thefourie2000 |
Post date | 2006-08-03T12:49:03Z |
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
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