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 ?



???

<orx />