Hello Again,
Tom: I looked into the software mentioned, but my project
is an application I'm developing on my spare time, so my budget
is small. It does look very good, but a bit too much money at this point.
Ted: The paper you supplied is great, I read it over and understood it
well enough. A good start.
Paul: The information you provided was helpful as well. I printed out
the mySQL full text search page and read it over. mySQL seems to have
everything I need for searching.
Since I'm doing a search of "title" and "body", I believe mySQL can
take me pretty far.
One question I still have is about building/rebuilding the indexes.
Is this done when new fields are added to the database?
Or a routine that needs to be done more often?
Thanks for you help everyone.
- Ben
----- Original Message -----
From: "Tom Melendez" <[EMAIL PROTECTED]>
To: "NYPHP Talk" <[email protected]>
Sent: Saturday, April 14, 2007 12:31 PM
Subject: Re: [nyphp-talk] SQL Full text searcing and storing
>
>I'd like to know if anyone can recommend a book or whitepapers on
>SQL for full text searching and storing.
Have you considered search engine software, such as mnogosearch?
You'll get all of the fancy heuristics (plurals, stopwords, page
element weight), URL indexing, query tracking, status code resolving
(what if the page is no longer available?), etc..
I realize that this isn't what you asked for and you probably aren't
building a search engine "proper", but you might want to check out a
search engine product anyway as it may resolve some of your
application issues for you.
Plus, mnogosearch has a PHP extension so you can talk to it directly,
get your results and display/use them as you like.
Good Luck,
Tom
http://www.liphp.org
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
