Searching facility on jboss cache pojo edition

[owklqm]

Hello everybody,

I am a new user of Jboss cache pojo edition, and I have a question about seaching data in the cache. In fact, I would like to achieve something like "SELECT * from table where text=?".

I have an application with higly volatile data, and I think I made a great choise by using jboss cache. Regarding writing performance, it is awesome compared to mysql performance, however, when it come to make something like "SELECT....", mysql tends to be better as with jboss cache I have to "find" all the node i need in a loop...

I have read about searchable edition, however, it seems it does not work with pojo edition.

Do you have any workaround for getting jboss cache better in this case?

Thank you in advance,

Regards.

PS : I would like to thank the development team for this great product. Sorry for my english...

[richard.qin]

you can integrate josql http://josql.sourceforge.net/ into jbosscache to provide sql-like seaching faclility.

[owklqm]

Thank a lot for the answer. It helps me a lot.

But I still have a question. Is there any reason that make findAll methods slower than a SELECT * in a mysql database? I thought caching my object would help in optimizing the access time.

Regards.