NYCPHP Meetup

[Paul Houle]

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.