At 11:12 AM 3/09/2007, you wrote:

>I am having a problem with the firebird super server which has its CPU peak
>at 100% for at least 30 seconds. I came across
>http://www.firebirdfaq.org/faq312/ which suggests a workable solution for me
>as the site already does a backup early in the morning whilst not trading.
>The system is also configured to restart Windows (XP) on completion.
>
>I wanted to know whether restarting the OS (and therefore Firebird) would
>have any effect on garbage collection.

Well, if a GC thread was in process at the time, it would die.

>Also if the site is already set to
>gbak with garbage collection and the the database is garbage collecting in
>normal operation, doesn't this suggest that there is enough garbage
>accumulating to need collection (or is the default sweep interval too
>small)?

The sweep interval doesn't determine whether or not GC takes place.

What version of Superserver are you using? If v.2.0.x, are you aware
that the default is to have both flavours of GC (background and
cooperative) occurring in parallel? If you're running this version
and individual users are getting hit too often with cooperative GC,
you might want to consider reconfiguring the GCPolicy setting so that
it does only background GC...

./heLen