Thanks - *I will test my scenario. just wanted to be sure you do not see obvious obstacles.* I intend to define the tables as "non persistent" so they are fully in memory. On Thursday, September 10, 2015 at 8:42:15 AM UTC+3, Thomas Mueller wrote: > > 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] > <javascript:>> 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]. >> 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. >> >
-- 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.
