Ben Sgro (ProjectSkyline) wrote:
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?
That's the beauty of it -- a mySQL fulltext index is maintained
automatically. Once it is created, it is automatically updated when
you insert, update and delete rows, just like any other index.
_______________________________________________
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
