Subject | Slow response on a big database? |
---|---|
Author | Mustafa Şimşek |
Post date | 2009-02-16T12:27:48Z |
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.
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.