Dear Tzahi, I lead the H2GIS project. For your information, the H2 database Engine ( with H2GIS ) is currently used in a research project (called Mapuce) to process all buildings and roads at the French scale and compute morphological indicators to evaluate climate changes. The database contains more than one hundred tables and millions of geometries.
Best regards -- Erwan Bocher --------------------------------------------- Ingénieur de Recherche CNRS, Laboratoire Lab-STICC – CNRS UMR 6285 Centre de Recherche - BP 92116 56321 LORIENT UNIVERSITÉ DE BRETAGNE-SUD T: +33 2 97 87 45 60 W: https://cv.archives-ouvertes.fr/erwan-bocher W: http://www.univ-ubs.fr Le mercredi 9 septembre 2015 13:33:00 UTC+2, צחי יעקובוביץ a écrit : > > Dear all, > We are evaluateing h2 for a project. > We have a database that is updated about 100 times per second. On each > update we evaluate a few hundred queries that test if the updated entity > answer the query.(we may batch it to once a second). The queries contain > complex spatial conditions, including joins based on spatial > conditions.Those queries bring our central DB to it's knees. > We have something between 10-40 miilion records in something between 30-80 > tables. Database size is betweeen 10-50 GB > We are considering the following architecture: > 1. Use h2 as an embedded, non-persistent DB. > 2. on startup, the embedding program will load the DB to the > current state > 3. replicate any change on our central DB to h2. > 4. the embedding java application will run the queries against the > embedded h2 > 5. for the spatial part, we will compare h2gis with a proprietry > algorithem. So even if h2gis is not ready for prime time - we can have a > solution > 6. target server will have at least 30 cores and 200 GB ram > > I need answers to a few questions: > 1. can h2 handle this architecture and load? > 2. does anyone use h2 as an in memory query server in a mission > critical enviro.nment > 3. can we get commercial support for h2? > > Thanks a lot if you got this far :-). > Regards, Tzahi -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
