I would be inclined to check system restore settings etc. similar
problems known with windows xp I believe whereas the first time you
attach to a db is restore is turned on in the o/s it tries to backup the
db.


-----Original Message-----
From: Milan Babuskov [mailto:albis@...]
Sent: 23 January 2004 15:48
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Windows 2003 oddities

Hi all,

I have problem with connecting to Firebird 1.0.3 SS on Windows 2003
server. It connects but slow. Once connected I can work without any
problems. Everything works great. When I disconnect, it also takes 5-10
seconds.

I did shutdown VSS (shadowing) and db file is named zz.fdb. Also,
Windows is "optimised for applications". I also added localhost to hosts
file.


Now what is interesting:

When I connect with isql, and stay connected, I open the second dos
prompt, and make another connection from it. It works instantly, like it
should. Opening each new connection works fast. Disconnecting too. If I
disconnect all clients, the first connection is slow again.


This leads me to conclusion, that there is some problem when Firebird is
reading the database file for the first time (attaching the database?)
Once the database is attached, new connections are made really fast.

Should I post my findings to the devel list?

--
Milan Babuskov
http://fbexport.sourceforge.net






Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/