GeoTools
  1. GeoTools
  2. GEOT-1430

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

        Hide
        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
        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
        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
        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
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: