> 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)

What's the file extension? If it's "gdb", do you have system-restore
enabled on the drive the database is on? (Windows XP setting)

> 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?

You can also search the archive - the problem has been discussed
several times.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com