On Tue, 15 Mar 2005 15:02:59 +0100, Martijn Tonies <m.tonies@...> wrote:

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

It's .gdb and I think system-restore is enabled... (default setting).
I will check this with the customer and disable it or rename the file to fdb...

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

Will do, thanks!
Yves

> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
>
>
> Yahoo! Groups Links
>
>
>
>
>