NYCPHP Meetup

[Ben Sgro (ProjectSkyline)]

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" <tom at supertom.com>
To: "NYPHP Talk" <talk at lists.nyphp.org>
Sent: Saturday, April 14, 2007 12:31 PM
Subject: Re: [nycphp-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