> There is a known bug in FB 1.5 that may
> cause the delays. To some
> extent it may help to use true
> local connection (not TCP localhost) or
> disable multithreading or processor
> cores in Bios. Also, any database
> activity run from a different
> connection usually "wakes up" the server
> when it freezes. The bug was fixed in FB 2.0. See
>
> http://tracker.firebirdsql.org/browse/CORE-419

Ok, that is confirmed. (from my side)

1. System restore was big problem
- Better but did not solve everything
- confiremed (with IBOconsole) that
any other query will Wake it up
(very well, but not 100%)
2. Now while testing classic server
- I see no pauses at all, much faster

I have following settings:

DefaultDbCachePages = 100
CpuAffinityMask = 15 //all 4 cores -> is this needed with Classic to use all
cores???

should I touch these (currently as defaults, meaning not set at all
(prefixed with #):
(and yes I did some Googling, but could not find good resource of tuning
Classic server)
SortMemBlockSize = 1048576
SortMemUpperLimit = 67108864

-TP-