Subject RE: [firebird-support] Slow inital connect...
Author Bogdan
Hi

Slow first connection is because of System restore of Win XP turned on.
It copyes database.
You should change *.gdb to *.fdb or turn system restore off

Bogdan

-----Original Message-----
From: Roberto Novakosky [mailto:rnovak@...]
Sent: Wednesday, March 16, 2005 7:26 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Slow inital connect...


Hello Yves

I have a identical system:
- Win XP SP2
- Firebird 1.5
- P IV 3.0E HT
- NTFS 1024 on SATA disc (but without RAID).
- I have other IDE disc with other databases .fdb too.

The conections are very fast...

I think must be something about the WinXP or something on WinXP, i have
other kind of applications OK on Win2k but with hangs on WinXP.

Roberto Novakosky
----- Original Message -----
From: Yves Glodt
To: firebird-support@yahoogroups.com
Sent: Tuesday, March 15, 2005 7:34 PM
Subject: [firebird-support] Slow inital connect...


Hello,

we are using Firebird since version 1.0 with databases sized between
10MB and 2.5GB.
Last week I encountered my first annoyance, and I think it's a known
problem, but I did not find more information about it :-(

Versions:
OS: XP Pro
FB: 1.5.2 installed as superserver
Box: P4 3GHz with hyperthreading enabled
Filesystem: NTFS on a RAID1 (Mirror)
Database is about 2.4 GB (single file)

The first (initial) connection our applications make to the server
(after XP has been restarted) make the applications hang for about 10
minutes (while they wait for data it seems). They seems to be frozen,
and nothing happens, except that the server seems to have heavy disk
operations. CPU load is unimportant (a few %)

After the 10 minutes have passed, suddenly everything works great,
with good speed and no problems at all.

It's the first time I encounter this problem, all our other DBs did
and do never take so much time, but they are also smaller... the
next-smaller is about 800MB.

What is this problem due to?

TIA and best regards,
Yves


p.s. I resend this message as the first one did not seem to get through...
:-(

[Non-text portions of this message have been removed]




Yahoo! Groups Links









--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.3 - Release Date: 15.3.2005