| Subject | Re: Is there a way to speed up gbak |
|---|---|
| Author | Adam |
| Post date | 2005-12-07T22:21:20Z |
--- In firebird-support@yahoogroups.com, "williamvdw2005"
<williamvdw2005@y...> wrote:
off to gbak. If it is not a 24/7 operation, you can always shutdown
the service, rename the file, then make a file system copy of it and
rename it back. Service Manager can backup faster than a simple TCP
loopback, so you can give that a try. Also try without garbage
collection (-g) and see if that improves things. If so, you actually
have a new problem. Why so much garbage has accumulated.
Adam
<williamvdw2005@y...> wrote:
>Could be a couple of things. Post the exact parameters you are sending
> Hi all
>
> I am using gbak to do backups (Firebird-1.5.1.4481). The page size of
> the database was set to 8k originally. After backing up a view hundred-
> thousand rows gbak slows down significantly. Is there any way to
> prevent this slowdown or make it less severe?
>
> Thanks in Advance
> William
>
off to gbak. If it is not a 24/7 operation, you can always shutdown
the service, rename the file, then make a file system copy of it and
rename it back. Service Manager can backup faster than a simple TCP
loopback, so you can give that a try. Also try without garbage
collection (-g) and see if that improves things. If so, you actually
have a new problem. Why so much garbage has accumulated.
Adam