Helen Borrie wrote:

> (or even the difference between a Kilobyte and a
> Megabyte!!)

Sorry I was just doing the conversion exactly as you quoted and didn't
use any MB/byte figures:

> > Read the Page size and Page buffers figures and multiply them together
> > and divide by 1024. Something around 300K would be the maximum, but
> > probably less if the application is doing a lot of sorts (ordered
> > queries, groupings...).

Page size 8192
Page buffers 3000
8192 x 3000 / 1024 = 24000

> The header info you supplied in another posting makes it
> obvious that the system was designed for Superserver. Users making their
> own arbitrary changes without knowing what they're doing are the bane of
> our lives!!!
>
> I'd strongly recommend that you contact the vendor for support about
> installing/reinstalling both the application software and the database
> and ask their advice about changing the server architecture. The
> transaction statistics indicate that the application seems to be taking
> reasonably good care of garbage. It looks as though you've been running
> this database for well over a year. Has it always performed badly?
>
> ./heLen
>

I honestly wish I did not have to do any of this firebird work, but
unforunately the application developers/support have been less than
useful and I'm trying to get the program running efficiently for the
client. It was at the suggestion of the developers support staff to swap
it to classic trying to imnprove performance but they did not provide
any configuration assistance with it.

If what you are saying is true about it basically being configured for
SuperServer mode, I think the easiest route would be to simply swap it
back to superserver mode and leave it as is, and I will then leave the
rest of the issues to be resolved by them.

The DB has performed badly since it was installed on the current server
(a rebuild). There have also been a few bugs they have been trying to
fix which have been impacting performance. I'll run some drive
diagnostics to see how the storage hardware is performing as well.

Thanks for the help Helen!

Cheers, Richard