I think you are running into one of my most lamented problems with firebird... if there is an aggressive connection (IE backup, or a really CPU/IO
intensive query), it absolutely refuses to play nice with the other connections. My guess is there is no (or not very good) scheduler in Firebird.

Jason

terriertech wrote:

> Hi all, I have sites that are working with a datafile 24 hours/day.
> Backups are run using gbak via a windows scheduled task at 4 am.
>
> Users are complaining that the backup slows down their work to a
> crawl. The GDB file is about 1.5 GB, the GBK file is about 1.4 GB,
> and the backup takes ~10 min. The server has 1 GB of RAM.
>
> Any hints for improving the client speed during backup? I am going to
> try lowering the priority of the gbak script process, but I suspect
> that everything is farmed off to the server process so this won't make
> a difference.
>
> Thanks!
> Justin R
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>