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?

Before it's possible to answer you question, you must give more info, eg:

What's the exact SQL statement it' slow?
What's it's query PLAN?
Have you narrowed that is Firebird that it's slow and not your app?
What's the OAT and Next Transaction when it comes to be slow?
It's aways slow or just after some time or at some hour in the day?
How many records are you querying?
Are you using SS or Classic? And what's your server machine profile?


Regards,
Anderson Farias