Subject Re: [firebird-support] Slow response on a big database?
Author Svein Erling Tysvaer
Have you looked at www.firebirdfaq.org/faq13/ ? Particularly note the
second point, that's a very common reason for a database to gradually
slow down.

HTH,
Set

Mustafa Şimşek wrote:
> Hi,
>
> i have a Firebird 1.5.5 Dialect 1 database about 1.5 GB. Sometimes my
> database response very slow. i do backup & restore and everything ok
> for awhile then start slow response again. i use Delphi 6 & IBX &
> Firebird 1.5.5 dialect 1. i have primary key and necessary foreign
> keys all the tables.
>
> 1) How could i determine what is the problem and how could i solve this problem?
> 2) I use events. Events to cause this problem?
> 3) if i upgrade Firebird 2.1.1, this help solve the problem?
>
> ps. sorry my english.
>
> Best Regards.