Subject | Re: One table become very slow |
---|---|
Author | marrtins_dqdp |
Post date | 2008-09-12T21:48:58Z |
It seems that gstat to finish will take as much time as gbak :(
--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@...> wrote:
--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@...> wrote:
>
> marrtins_dqdp wrote:
> > My table is very slow, not just a bit. It contains ~4000-5000 rows
> > (cannot tell precisly now, `couse count(*) takes tooo long)
> >
>
> If you have a copy of the database, run gstat -a -r on it and find
> the part of the report that describes the CLIENTS table. That may
> provide a clue.
>
> Good luck,
>
> Ann
>