Subject | How to tune Firebird for smallest memory footprint? |
---|---|
Author | Nathan Probst |
Post date | 2006-05-29T20:00:46Z |
Hi all,
I've got a Firebird-based app almost ready to roll out, and I'm wanting to
tune the Firebird server that is distributed with it, to minimize the
average memory footprint over time. I don't have any experience with tuning
the server, and I'm hoping someone out there can help me...
So, here's my requirements:
- Using SuperServer
- Moderate (64MB max) memory usage under load is OK
- Minimum memory usage (<8MB) )when server is not under load
This database server accompanies a system extension and is always running.
Connection is via TCP and shared across a few processes. Work occurs in
bursts, when max performance is desired, but most of the time, it's just
waiting and should minimize resource usage.
Thanks guys!
Nathan Probst
[Non-text portions of this message have been removed]
I've got a Firebird-based app almost ready to roll out, and I'm wanting to
tune the Firebird server that is distributed with it, to minimize the
average memory footprint over time. I don't have any experience with tuning
the server, and I'm hoping someone out there can help me...
So, here's my requirements:
- Using SuperServer
- Moderate (64MB max) memory usage under load is OK
- Minimum memory usage (<8MB) )when server is not under load
This database server accompanies a system extension and is always running.
Connection is via TCP and shared across a few processes. Work occurs in
bursts, when max performance is desired, but most of the time, it's just
waiting and should minimize resource usage.
Thanks guys!
Nathan Probst
[Non-text portions of this message have been removed]