Suggest me an embedded database engine(for Java) to store 1000000 records in minimum time.
It should provide the full text search facility (Actually i want Firefox's Awesome-bar like FTS searching us开发者_StackOverflowed to search any combination of characters) The database should be stored in compressed format on disk.It should not be GPL
. Apache 2.0 will be better.
Suggestions are open for NOSQL too.
Look at OrientDB: in embedded mode stores, on my notebook, 1,000,000 of records in 4-30 seconds depending on the record type. It has a FullText index and it's 100% Java and has Apache 2 license.
Seems perfect, don't you? :-)
One million records is not that many. You can use a Map for records and a NavigableMap for the text search. You can store the data on disk using a DeflatorOutputStream and InflatorInputStream.
精彩评论