You're probably bitten by system restore under Windows XP. Rename your
database to .fdb rather than .gdb and your problem disappears. And keep
forced writes true unless you want to lose data!

Set

At 15:15 16.07.2003 +0200, you wrote:

>Hi !
>
>
>I have a Java-based client-server document-management system running on
>an firebird database.
>Everything worx fine!
>It stores all data in a huge single gdb, including binary Data.
>
>I have converted it into a one tier application for win32 and experience
>performance Problems during the first requests.
>( and java-startup-time is long enough )
>
>I think this is no java-based Problem, after restart of the app+firebird
>everything is quite fast. But after reboot under XP;
>
>On first startup after booting when calling something like
>
>final DatabaseMetaData meta = db.getMetaData();
>final ResultSet rs = meta.getTables(null, null, "%", new String[]
>{"TABLE"});
>
>needs about 75 (!) seconds on a 180MB File. The Harddrive is working
>heavy during this time.
>
>I removed the code because I don't need it really, and now the 75
>seconds are needed later. Seems that firebird needs to scan the complete
>file .
>
>What is going on there ? It's only the first time after booting. Once you
>have done it, it's done in less than a second.
>
>On top of firebird for linux it only takes about 4 seconds. ( same
>machine on same gdb-file on same fat32 Partition )
>But thats no solution for my Win32-Application-problem .
>
>Any ideas how 2 avoid this initial startup procedure/file scan ?
>
>
>I tried FB 1.02, 1.03, 1.5 with interclient,JBird and jre1.4.2,1.4.1
>.... always the same result. Tests are annoying when you always have to
>reboot
>
>
>I tried to perfom a sweep in IBConsole and I switched to "forced
>writes"(even if I don't know what it means). Seems to have no effect.
>
>Is there a way to perform this scan on System-start ?
>
>
>
>???