Subject Re: [firebird-support] Slow database operations...
Author Helen Borrie
At 12:53 AM 6/01/2004 -0500, you wrote:

>Hi all,
>I'm on pcanywhere with a clients installation site and they are having
>some real slow database operations. They are using Win2000 P4 256 MB
>RAM, etc.
>At first IB open edition was installed and exhibited this behavior. For
>instance, operations that normall take a few seconds started taking 20
>secs, etc.

This kind of slow-down usually indicates long-running transactions,
regardless of whether it's IB or Firebird. Possibly too many Autocommits
(which do CommitRetaining, not a hard Commit, and prevent garbage
collection from proceeding). Have you checked the gap between OIT and Next
Transaction recently, with isql Show Database?

>So I upgraded them to new FB 1.5 RC6. Did a back up of the database
>(size = 150MB) after un-installing IB

Erk, that's not the recommended way to upgrade. You should back up using
the original server's gbak, then restore using the new server's gbak.

> and installing FB and it actually
>took an hour to back up. I am doing the restore now and that is taking
>about as long.

Cross fingers that nothing gets busted, then.

>Everything was working fine before and I have no idea
>what would cause this.

I hope you still have a good copy of the original database...