Hi Richard!

Just to be certain - you have checked the queries of the app itself?
Poor design (e.g. asking for all too many rows or count to show a
progress bar) or poor plans chosen by the optimizer are quite common
reasons for poor performance, and fixing such issues have far greater
impact than any configuration tweaking.

Set

Richard Ap-Thomas wrote:

> Hi Guys,
> I'm trying to troubleshoot a poor performance issue with a firebird DB
> based app for a client. They are running a 15 GB database, ~40 users, on
> a windows 2003 server (single drive, raid5), dual Xeon and 2 GB RAM.
> Currently it is in classic server mode, and I believe a default config
> file apart from the CPU affinity.
>
> Now I'm wondering if anyone can give me or point me in the right
> direction for a set of changes I should be making to the firebird.conf
> file as a baseline. I've had a hunt around and believe theres a couple
> of settings for max memory and temp dirs but was hoping for a complete
> list as a starting point.
>
> Thanks, Richard