Hello together, I would like to use the H2 Database in a special use case and would be very happy, if someone could tell me if H2 is a suitable tool for my problem:
- I have an amount of 20000+ objects stored in a ConcurrentHashMap. These objects have to be tagged with multiple key-value pairs. After the tagging I have to execute some search operations to retrieve a single object or a list of objects matching the search parameters. - The number and name of the keys are known. The value type can be String or int. - The searches are simple selects with combinations (AND, OR, ...) on comparisons over the values (not null, ==, >=, ...) - Once the tagging of one object was done, it will not change again. But the objects itself can be deleted (and so the tagging information) or newly created (with a new tagging). - There will be many parallel threads executing search operations. So changes to the objects and searches over them have to be tread-safe! - There is no need to have a file based storage after closing the JVM. I only need a container for runtime informations, which provides a fast response on multithreaded access. The database would contain only one table with a large amount of entries. Do you think, I could use H2 in embedded mode to store the tagging informations and execute the search operations? Kind regards, Lars -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
