We embed HSQLDB (v1.8) in our application for use as an in-memory cache for data which cannot be indexed using key-value syntax. All database connections use "jdbc:hsqldb:mem:DB" to connect to the database. Since these databases are not accessible from any JVM outside the one in which the database was created, for performance reasons, we wanted to allow objects to be stored in the database without serialization.
We customized the code to introduce a new datatype MEMOBJECT which allowed objects to be stored and retrieved in in-memory mode. However, these objects cannot be indexed. This provided for significant performance benefit.
Is there any need / scope / requirement to integrate in feature into core HSQLDB database?
it is perfectly feasible to add this in 2.3 or even earlier.
In fact it would be possible to add a database property flag for mem: databases which results in the objects of OTHER data type to be stored without serialization. This would avoid extensive changes to the existing code. We would develop this ourselves.
< Previous |
Add a Reply
This forum does not allow anonymous participation.
Log in to add a reply. Not registered? Create an account to participate and receive email updates when replies are posted to this topic.