Subject | Re: [firebird-support] Big table and DB slowdowns |
---|---|
Author | Jerome Bouvattier |
Post date | 2004-08-31T20:07:18Z |
One more precision...
playing all the afternoon with it issuing the guilty statements dozen of
times against various part of the table. And suddenly, speed went back to
normal.
Note that, between statement executions, fbserver.exe did not eat any CPU
power. It's really only during statement execution that "something" happens.
Regards.
--
Jerome
> - To fix the pb ( until the next slowdown ), all I found is to sweep thedb.
> It takes about 20 minutes, which is no more than the regular sweepingActually, I just noticed the db could cure itself without a sweep. I've been
> duration for this db.
playing all the afternoon with it issuing the guilty statements dozen of
times against various part of the table. And suddenly, speed went back to
normal.
Note that, between statement executions, fbserver.exe did not eat any CPU
power. It's really only during statement execution that "something" happens.
Regards.
--
Jerome