Re: [Firebird-test] Firebird Win32 (any version) slow on some Databases on 1st connection.

[Dmitry Y. <di...@us...>]

"mrqzzz" wrote on Sun, 31 Aug 2003 11:19:59 +0000 (UTC):

> Notes:
> -It happens on a few DBs only, and always on the 1st connection after a
> reboot
> -The freeze happens by simply starting a transaction
> -The Dbs are intact and coerent (backup & restore goes ok)
> -There are 20 or 30 tables, many Fk, some Sp, some Views, no Blobs.
> -The time seems to increase with the DB size
> -I had this problem on some DBs ever since old Interbase 5.x
> -The freeze still happens with ANY Firebird version,
> -The freeze happens on ANY Windows version (95/98/Me/2000/XP) even with
> 1 Mb RAM.

Set the sweep interval to zero and perform it automatically at night. It
should be the best solution. Please, send your support questions to
fb-support.


Dmitry