Subject Re: Slow performance with 70 users
Author diegodelafuente
I used the IBAnalyst trial version. I bought the full version, but i
still waiting for it.
I change the sweep interval to 0. That improve the performance a
little.
In the reports of the DB apears a lot bad indexes, because they have a
lot of equals Data on it. But These indexes were created for F.Keys
and they cannot be deleted until I delete the F.Key.
I don´t won´t to do that, because i use them for Data Integrity.
How can I solve this problem ?

Again sorry for my english
Diego

--- In firebird-support@yahoogroups.com, "Dimitry Sibiryakov" <SD@...>
wrote:
>
> On 5 Apr 2006 at 12:07, diegodelafuente wrote:
>
> >if the problem is a Badly written application the problem, I can
seek
> >the bad code recreating with 2 o 3 pcs and another server where is
the
> >problem (running the proceess and compare the CPU utilization). That
> >was done, but we coudn t find something bad.
>
> Try to use IBAnalyst. It'll show possible problems.
>
> --
> SY, Dimitry Sibiryakov.
>