Re: Re: New search related question
| From: | Greg Donald | Date: | Mon, 04 Feb 2008 20:55:23 +0000 |
| Subject: | Re: Re: New search related question | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-268674@lists.php.net to get a copy of this message | ||
On 2/4/08, Shawn McKenzie <nospam@mckenzies.net> wrote:
> I agree that htdig may be a better solution, however his current
> solution requires upkeep if the static HTML is changed and requires that
> the person populating the database pick all relevant words from the page
> and if new ones are added to update the db.
Oh the horror of setting up cron jobs and stopwords.
> Unless, by FULLTEXT, you're implying that the full text of each page
> should be in the db, then I would argue that there is negligible diff
> between that and the grep.
Here, let me connect the logic for you.
Q. If grep was the best search tool then why did slocate get invented?
A. Indexes.
A MySQL index doesn't go away in between requests.
--
Greg Donald
http://destiney.com/