Subject Re: [firebird-support] Slow database operations...
Author Don Gollahon
"Lee Jenkins" <lee@...> wrote in message
> 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.
> So I upgraded them to new FB 1.5 RC6. Did a back up of the database
> (size = 150MB) after un-installing IB 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. Everything was working fine before and I have no idea
> what would cause this.

Could be any of several things. Is this a new site using your system? Is
anything else using the processor? No screen savers running?

What operations are slow? Inserts, deletes, updates? PCAnywhere host isn't
interfering with it is it?

Is Firebird and your client app running on the same machine?

> --
> Warm Regards,
> Lee