Well I've been trying to get the searchable plugin to work with my current app, but there is one thing that bothers me:
Every search relies solely on the Lucene index.
And that leads to some disturbing problems (like this: http://jan-so.blogspot.mx/2009/04/eager-fetching-and-searchable-plugin-in.html). Basically, every one-to-many relationship will have a null value in a search result. To avoid that, you must make a lot of you Domains searchable, but well, that means that half of my database will be mapped into the Lucene index ... and that just sounds wrong.
I'm currently in development environment, so everything is loaded into memory, and Lucene makes java to use at least 40% more memory (a total of 1.2GB is used, and I have restricted what to include in it as much as possible with only
and exclude
).
So, can I stop it from relying just on Lucene index? I want it to search on the index but no to return only what the index has. Or is it really convenient to keep everything in the index (and thus doing it the searchable way) rather than making manual HQL queries?