Dear H2 group, I'm planing to develop an application, and I have studied the document and tested some simple codes, H2 might be a good choice for my application. Before going further, I wish to get more comments from you experts, especially the performance.
In my application, there will be a lot of insert and select operatons, and seldom update and delete operations. I estimate the data will grow up to 2TB or even more after one year. From the document, it seems no limit for data file size untill reaching OS's limitation. 1. Is H2 a tiny DB engine? is it suitable for large database? 2. For better performance, should I keep all data in only one file? or split the file into smaller pieces? 3. Regarding the 2-nodes HA cluster, do these 2 servers access the same data file? Can I set up NFS for these 2 servers to share the same disk space? BR, James -- 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/groups/opt_out.
