Subject RE: [firebird-support] Performance problems - need help urgently
Author Alan McDonald
> Yesterday something very strange happened. I tryed to test the
> client in another equipment with Windows XP with Firebird in my
> local machine. When connecting to the
> database "localhost:c:\database\simulator.gdb" I found out that the
> time for the connection was very high (20 seconds or more). changing
> to a remote connection "othermachinename:c:\database\simulator.gdb"
> the connection was very fast (1 sec or less). I could not find the
> reason for that and will try today at home to find it out.
> Is there some paperwork, documentation, personal experiences that
> you could share with me to solve this huge Firebird new user problem?
> Thank you very much and my apologies for writing so much.
>

The localhost and XP problem should be that you have system restore turned
on and the gdb files are being backed up when you first connect.
Either rename the files to .fdb (use firebird 1.5 to ensure that the
security database is security.fdb and not isc4.gdb)
OR
disable system restore on that XP machine

Alan