Am building a query dynamically and executing the script using plain JDBC. I need to increase DB performance. How does Lucene help to increase the performance. IS there any resource to use Lucene for a plain JDBC call?
Lucene is a library for indexing and searching data. As such it provides additional functionality, but not so much performance gains (unless you have determined that's it's precisely those areas that need speeding up). What kinds of searches are you thinking about that are currently too slow? Can you describe your data to us, and the way you're currently searching?
Actually we have a joing on 2-3 table which fetches the data. Also our search had to support free text search. The data in the tables ranges from 80k to 140k records.Currently we are using the oracles CTX index , but thats not that effective. Do you think Lucene fits in our env
140k Documents (the Lucene unit of search) is certainly not too much for Lucene to handle (or for a DB, for that matter). I'm guessing that the difficulty is in the search logic, so it's hard to advise without knowing how the data will be searched (which criteria, which combinations, etc.)
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop