db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steen Jansdal <st...@jansdal.dk>
Subject Re: Derby/Cloudscape GUI??
Date Wed, 25 Aug 2004 13:37:52 GMT
Alexander Schatten wrote:
> Steen Jansdal wrote:
> 
>>
>> And there are at least two things that makes hsqldb unusable for me.
>>
>> The database can not be larger than 2 Gb.
> 
> 
> this is true
> 
>>
>> Its not failsafe. The log file are not flushed to disk after a commit.
>>
>>
> but I do not get this point. actually, every change in the database is 
> stored immediately to the log file. I tried making changes to a database 
> and turned off the computer withou shutting down the server properly 
> (with memory tables!) and everything was reconstructed properly.
> 
> 
> Alex
> 
> 

See in the user guide under "Set Write Delay". It looks like hsqldb
has a log flusher thread, that as default flushes the log once every
60 seconds. You are not able to set this value lower than 1 second.
You can loose a lot of log entries in 1 second.

Steen

Mime
View raw message