Hi,

I have noticed similar behaviour with my applications - although I only
noticed it when starting to use embedded server.

I was wondering if it may in my case be because the database server(being
embedded in the application) does not cleanly
disconnect from/shutdown the database(I currently still have connections
open when the app exists) and then when next
starting needs to do some kind of crash recovery ?

Just a thought.

Ryan

-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: 16 July 2003 00:11
To: Firebird-Java@yahoogroups.com
Subject: Re: [Firebird-Java] Strange initial startup behavior


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/

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/