I have used h2 as cache for analytics query. This is working very well. Things to consider - manage connection pool and make sure you keep atleast 1 open - when doing changes use copy on write pattern to avoid any slowness on read query. Disk are very cheap! - disable all the index before large insert and enable it again. - choose your index based on read access pattern - compact database after large insert. - Shard db based on performance requirement.
Using these strategy I am able to manage close to billion records and giving millisecond response time Regards Ashkrit sharma > On 27 Jun 2020, at 03:53, Leonel Gayard <[email protected]> wrote: > > > Looks like a good strat. > > For people coming from a search engine, here's the command to rename a table: > http://h2database.com/html/commands.html#alter_table_rename > > >> On Fri, Jun 26, 2020 at 4:47 PM Noel Grandin <[email protected]> wrote: >> last line should have been >> >> "rename new table to proper name" >> -- >> 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 view this discussion on the web visit >> https://groups.google.com/d/msgid/h2-database/CAFYHVnU-mLeAQ9%3DLT6HQpVsv2%2B_xMsqVz7h2KZfSF1Ze4ftatw%40mail.gmail.com. > > -- > 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 view this discussion on the web visit > https://groups.google.com/d/msgid/h2-database/CADOcxwCHK_rVT%3DQFYBZ%3Dbwc%3DqJYZErTFFyzfV%2BSQu8RWYytvKg%40mail.gmail.com. -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/571BD336-5FDD-48B3-AF38-10A5316DEFF5%40gmail.com.
