Good Morning!

I am new to this list, so if this has already been answered,
please point me to the answer.

In a production environment, I am using Firebird RC2. I moved to
RC2 because the IB6 engine messed up my generator values, starting
with the 126th generator. Because of that, I had not been able to do
a backup/restore for many months (since moving to IB6) and the
indexes were way out of balance. The performance was really bad. Some
transactions were taking minutes to complete.

The upgrade went OK.

I also tried (and am still trying) several of the recommended
tuning options. So far, performance is still baaaaaaad!

I have set the number of page buffers to 65535, increased the page
size to 4K and 8K, set the processing priority to 2, used ib_affinity
to set the cpu to 1, set SERVER_WORKING_SIZE_MIN to 300MB and
SERVER_WORKING_SIZE_MAX to 500MB (1 GB in server). Nothing seems to
help.

I use the NT perfomance counters to watch IBServer. It is
frequently maxed out at the top (flatlined!)

I have included an external DCOM app to monitor what the main app
is doing (reports, grids, forms). When several resource hungry
reports are requested at the same time, I can see that the engine is
maxed out.

The app is using TTables (not my idea, someone else wrote the
app). I have tried to make sure that all tables and queries are
closed when the app starts and when the forms (~600 of them) are
created.

The owner is pulling her hair out and is ready to trash the whole
thing and buy something else.

What else can I try? What can I look at to find the problem?

Thanks...Dan'l