I have a Java-based client-server document-management system running on
an firebird database.
Everything worx fine!
It stores all data in a 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 )

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 .

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

<orx />