Hi Nick. I've found that my applications ALMOST hang when sweep is running
in big databases (100GB+).

I say almost because once in a while the application give a sign of life.
To "solve" the problem, i disabled the autosweep and run in a scheduled
task every dawn.

Best regards.

On Tue, Jan 15, 2013 at 12:29 PM, Nick Upson <nu@...> wrote:

> Hi,
>
> (firebird 2.1.5 on centos) 50Gb database
>
> Is there any reason why a process, upon noticing the transaction gap is >
> 20000 & hence a sweep is required, should 'hang' (for hours), as if waiting
> for the sweep to complete.
>
> Is there any way I can tell (logging or process monitoring perhaps) when an
> automatic sweep is initiated, running or completed?
>
> --
> Nick Upson, Telensa Ltd
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org 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
>
>
>
>


[Non-text portions of this message have been removed]