I just started learning about Lucene and I get how it can be very useful for searching documents and such, but does anyone use it for searching database data?
For example,
I need to make a search that will search for keywords based on two fields ("description", "message").
To do this I would need to write an sql query to return all the description rows, and all the message rows (could be tens of thousands), then from that create an index, and search the index.
Is my understanding correct? I would first have to get all the data from the database which could be huge.