This is a follow up to a question i asked at java disc based hashmap for a disk based hashmap.
The solution suggested works but at a high CPU cost. I've tried using a few embeded databases, including hsqldb and derby as well as an sqllite implementation in java.
The all get the job done, quite slowly for most of the ones i've tried, the three i mentioned beformed the best. I ran into one problem with all of them however. Starting and maintaining each embeded database required a lot of CPU time, the ones i haven't mentioned used up 100% of the cpu most of the time,according to task manager.
My new question then is, are there any simple disc based storage that won't eat away my cpu.
for the record, the sqllite solution didn't spike cpu usage it was just crashing with a range of different errors. And apache derby had the best performance and cpu usage fluctuated with it but on average was about 80%
I have no experience with other embedded java DB then Apache Derby and HSQLDB. Some links:
Did you tried some NoSQL DB?
Here is a list of NoSQL databases. I have no experience with them. But MongoDB and CouchDB are quite famous. And also Db4o looks interesting.