A Firebird 1 database. It used to run very fast, lately it has become
very slow. gdb is about 60 MB. I am having a copy in my developement
machine and from time to time I restore a production database into my
machine to develop with real data volumes. For example with about month
old gdb, ISAPI application runs fast as lightning, with new gdb response
comes about 5 seconds. ISAPI application is same, I only change target
database.
I talked to some collegues, who maintain it on production site and they
said is has also become slow in production as well.

I believe problem is somewhere in database maintenance.
I searched older messages and noticed some things to be done:
1)run database sweep
2)run SET STATS to rebalance the indexes
3)validate database

is there something else?

What I have done:

1)

in IBQuery when I run database sweep I get
Sweeping database...
dmMain.ValidationService:
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements.
Unable to complete network request to host "RAIGONT".
Failed to establish a connection.
No connection could be made because the target machine actively refused it.
.

Elapsed time: 2.13 s

why? it is my local machine, no firewall, all ports are open.

When I run database sweep in IBOConsole it works and does sweep (tells
at the end Database sweep completed).

2)I ran command
SET STATS
in IBOConsole.

3)to validate database I used IBAccess with options Ignore checksums,
Kill unavailable shadows, Validate record fragments. at the end I get
form with caption 'Service process' and one empty line.


I ran my web application, it has become a little bit faster, instead of
5 seconds response comes now in about 3. But still it used to be so fast
that the moment I cliked mouse I already had next page. the data volumes
of these tables are not much bigger, most of them are about same size.

What else can there be done with maintenance tools to speed up/repair
Firebird gdb?

thanks
Raigo