[#OF-269] Make certain HSQLDB cached. - Jive Software Open Source

Openfire

Make certain HSQLDB cached.

Created: 04/16/06 05:18 AM Updated: 02/01/10 01:27 AM

Component/s:

Database

Affects Version/s:

3.6.4

Fix Version/s:

3.7.1

Time Tracking:

Not Specified

Acceptance Test - Add?:

Description

« Hide

Make certain HSQLDB tables of type CACHED (CREATE CACHED TABLE...). This will decrease memory usage in cases where a lot of data is going into the db.

All

Comments

Work Log

Change History

FishEye

Sort Order:

[ Permalink | « Hide ]

LG added a comment - 04/21/06 10:14 PM

I just converted all tables to CACHED ones, this did work fine as the db file was read. Then I got a new .data file with the values in it, it is no longer possible to just edit the wildfire.script file as the data is not stored there and the wildfire.data file contains some escape characters.
So I wonder if one should really change the table creation or changing the Wifi cache sizes to zero is better.

[ Permalink | « Hide ]

Daryl Herzmann added a comment - 05/28/08 09:00 PM

Hi LG,

Any more on this issue?

daryl

[ Permalink | « Hide ]

LG added a comment - 07/05/08 03:13 PM

Hi Daryl,

I did never try this again. As the embedded database should only be used for evaluation I wonder if it would be better to keep the current settings. So one needs more memory but with 1-100 users there should be no problem.

It may be interesting to run a load test with CACHED and with MEMORY tables and monitor the performance and the memory usage.