Good Morning!

Thanks for the info. I have kicked all users out
and set the bufferes to 10,000. I did not set the
affinity with IBConfig.

I also set back to 1 for the processor priority.

I'll see what kind of difference this makes.

I have been working on indexes.

Tables cannot be removed at this point. It will
take a major re-factoring effort to switch to queries.

Thyanks...Dan'l


--- "Leyne, Sean" <sleyne@...> wrote:

> Dan'l
>
> > ... I have set the number of page buffers to 65535
> ...
>
> Change this value to 10,000 -- there has been some
> evidence that a value
> above that setting actaully reduces performance.
>
> > ... set the processing priority to 2...
>
> Restore that value to the original, this value has
> the opposite effect
> in many cases.
>
> > ... ib_affinity to set the cpu to 1...
>
> I would suggest you use the IBCOnfig CPU_AFFINITY
> setting, it ensure
> that if the server is restarted that the affinity
> setting is restored
> correctly.
>
>
> > ...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.
>
> Your performance problem can best be traced to a
> poorly designed
> application, TTables!!!! and most likely poorly
> indexed/optimized
> queries.
>
>
> Sean
>

=====
____________________________________
Every day is a Great day, but
some days are GREATER than others!

__________________________________________________
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/