db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamatha Kodigehalli Venkatesh" <Mamatha.Venkat...@ness.com>
Subject Does derby database need periodic maintenance/cleanup activity ?
Date Thu, 20 May 2010 07:00:51 GMT


Hello,


I have been using derby for almost a year and a half and current version is db-derby-10.5.1.1-bin.

It is observed that, if derby database runs continuously for say around 5 hrs. It becomes
really slow for further queries even with fresh DB calls.

Tried re-creating indexes to speed us the DB.

Please let me know if I need to take care to clean up the cache or logs to speed my existing
DB.

Thanks
Mamatha

Mime
View raw message