GeoTools

Replace HSQL database by H2 for EPSG factory

Details

  • Type: Improvement Improvement
  • Status: Resolved Resolved
  • Priority: Minor Minor
  • Resolution: Won't Fix
  • Affects Version/s: 2.5-M0
  • Fix Version/s: 2.7.5
  • Component/s: referencing
  • Labels:
    None

Description

HSQL loads the full EPSG database in memory before usage, which is slow and consume a lot of memory (4 Mb). H2 has been reported faster and more reasonable on memory usage. Furthermore, H2 is under consideration for adoption by the Geoserver project, and we will probably want to avoid usage of 2 database engines in the same JVM.

Given that the H2 API is very close to the HSQL one, it should be easy to switch from HSQL to H2. But we may need to wait for one remaining issue before we can switch:

http://groups.google.com/group/h2-database/browse_frm/thread/ef14b5a50a3d8961

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Martin Desruisseaux added a comment -
Attached a H2 module adapted from HSQL by Andrea.
Show
Martin Desruisseaux added a comment - Attached a H2 module adapted from HSQL by Andrea.
Hide
Permalink
Andrea Aime added a comment -
HSQL does not load the whole tables afaik, but only a cache... it's just the cache is big :)
Also, I repeat, I did not make any memory check.
Show
Andrea Aime added a comment - HSQL does not load the whole tables afaik, but only a cache... it's just the cache is big :) Also, I repeat, I did not make any memory check.
Hide
Permalink
Martin Desruisseaux added a comment -
Oups! Sorry if I was too optimist about H2.

An other database to take in consideration is Derby.
Show
Martin Desruisseaux added a comment - Oups! Sorry if I was too optimist about H2. An other database to take in consideration is Derby.
Hide
Permalink
Jody Garnett added a comment -
H2 is being retired so marking this as won't fix.
Show
Jody Garnett added a comment - H2 is being retired so marking this as won't fix.

People

  • Assignee:
    Jody Garnett
    Reporter:
    Martin Desruisseaux
Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: