Hi, I don't think anybody can answer this. You will have to write a test case to find out if H2 is fast enough for your case, with that amount of data.
If the database size is between 10 and 50 GB, and 200 GB RAM, I would consider using a huge cache so that all the data is in memory. Maybe full in-memory operation. Regards, Thomas On Wednesday, September 9, 2015, צחי יעקובוביץ <[email protected]> wrote: > 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] <javascript:;>. > To post to this group, send email to [email protected] > <javascript:;>. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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.
