Subject RE: [firebird-support] Re: Open and Close connection to Firebird 1.03 972 server is slow in Windows XP
Author Leyne, Sean
> From: chaucheeyang [mailto:ccy@...]
> Sent: Wednesday, August 18, 2004 9:10 PM
> ...
> It is only connect/disconnect operation are slow. Other operations
> are just fine. But that is also an unacceptable behavior as it
> takes about 30-40 seconds for user to logon or logout.

Are you are using the old FB/IB '.gdb' extension for your database
files?

If so, this is a known issue with Windows XP and XP's new System Restore
'feature' -- which treats all files with the 'gdb' extension as XP
system files.

To overcome this issue you can:

- disable the System Restore feature, via the System Control Panel, or

- change the extension on the database files to '.fdb'. Please note
that there is a special procedure which you must follow to rename the
"isc4.gdb"/security database.


Sean