Subject | Re: FW: FW: [firebird-support] database of 9mb is extremely slow! ref/eDN8022297953 |
---|---|
Author | Ann W. Harrison |
Post date | 2007-12-20T17:47:58Z |
dennis wrote:
need to figure out why that one database has transactions that stay open
for a long time. The gstat output you gave us was from your pc with a
copy of database. Obviously, the offending long transaction didn't get
copied, so the stats looked fine. They won't be fine at the client
location.
Good luck,
Ann
>OK, then the problem is that you've got uncollected garbage. You'll
> Anyway, something else, with backup restore without backuping the garbages
> the database it works perfect. Can we to this "garbage delete" with more
> easy way except the backup and restore way?
>
need to figure out why that one database has transactions that stay open
for a long time. The gstat output you gave us was from your pc with a
copy of database. Obviously, the offending long transaction didn't get
copied, so the stats looked fine. They won't be fine at the client
location.
Good luck,
Ann