lucene-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "thomas Armstrong" <>
Subject Lucene or Sphinx? I want to search within +200,000 record tables
Date Fri, 04 Jan 2008 13:32:40 GMT

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.

View raw message