At 09:37 PM 15/07/2003 +0200, you wrote:

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

Noting the discrepancy between Linux and Windows that you report, my guess
is that you are using WinXP or WinME and have a database file with a ".gdb"
extension. If this is the case, try renaming the file with ".fdb"
extension and see whether it changes the behaviour.

See the Firebird 1.0 release notes for an explanation.

Helen

><orx />
>
>
>
>To unsubscribe from this group, send an email to:
>Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/