Hi. I created a website with two +200,000 record tables cointaining information about:
Table 'items' - id - title - text - tags - date - rate - user_id Table 'comments' - id - item_id - title - text - date - user_id And I would like to search within them. I created some MySQL queries but they are v-e-r-y s-l-o-w. So I'm trying to find another solution and I'm considering Lucene or Sphinx. As far as I'm concerned, Lucene would crawl and index webpages and Sphinx would build an index over the table, right? Which could be the best solution in your opinion? Thank you very much.
