Openfire

Make certain HSQLDB cached.

Details

  • Type: Improvement Improvement
  • Status: Open Open
  • Priority: Major Major
  • Resolution: Unresolved
  • Affects Version/s: 3.6.4
  • Fix Version/s: 3.7.1
  • Component/s: Database
  • Acceptance Test - Add?:
    No
  • Description:

    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.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
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.

Show
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.
Gaston Dombiak made changes - 06/20/06 06:51 PM
Field Original Value New Value
Fix Version/s 3.0.0 [ 10450 ]
Fix Version/s 3.0.0 beta [ 10421 ]
Gaston Dombiak made changes - 06/29/06 09:05 PM
Fix Version/s 3.0.0 [ 10450 ]
Fix Version/s 3.x [ 10181 ]
Hide
Permalink
Daryl Herzmann added a comment - 05/28/08 09:00 PM

Hi LG,

Any more on this issue?

daryl

Show
Daryl Herzmann added a comment - 05/28/08 09:00 PM Hi LG, Any more on this issue? daryl
Hide
Permalink
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.

LG

Show
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. LG
Daryl Herzmann made changes - 01/11/10 06:09 PM
Component/s Database [ 10233 ]
Fix Version/s 3.x [ 10181 ]
Fix Version/s 3.6.6 [ 10861 ]
Component/s Database [ 10003 ]
Key JM-643 OF-269
Affects Version/s 2.6.1 [ 10400 ]
Affects Version/s 3.6.4 [ 10855 ]
Project Openfire (ARCHIVED) [ 10010 ] Openfire [ 10140 ]
Daryl Herzmann made changes - 01/31/10 08:35 PM
Fix Version/s 3.6.6 [ 10861 ]
Fix Version/s 3.7.1 [ 10855 ]
Daryl Herzmann made changes - 02/01/10 01:27 AM
Affects Version/s 3.7.1 [ 10855 ]
Affects Version/s 3.6.4 [ 10870 ]

People

Dates

  • Created:
    04/16/06 05:18 AM
    Updated:
    02/01/10 01:27 AM
Atlassian JIRA (v4.1.2#531) | Report a problem | Request a feature | Contact administrators
Powered by a free Atlassian JIRA open source license for igniterealtime.org. Try JIRA - bug tracking software for your team.