Subject | Re: Slow performance with 70 users |
---|---|
Author | diegodelafuente |
Post date | 2006-04-10T20:51:05Z |
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:
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:
>seek
> On 5 Apr 2006 at 12:07, diegodelafuente wrote:
>
> >if the problem is a Badly written application the problem, I can
> >the bad code recreating with 2 o 3 pcs and another server where isthe
> >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.
>