NYCPHP Meetup

NYPHP.org

[nycphp-talk] SQL Full text searcing and storing

tedd tedd at sperling.com
Mon Apr 16 12:17:27 EDT 2007


At 11:59 AM -0400 4/16/07, Ben Sgro \(ProjectSkyline\) wrote:
>Hello Again,
>
>
>"    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."
>
>- or -
>
>>My understanding (I could be wrong) is that every time you add more 
>>data, you have to rebuild the index to be able to use FULL TEXT. 
>>However, that doesn't need to be done until the next search.
>
>Which is it?

Like I said, I could be wrong -- I would go with the other advice OR 
ask the MySQL list.

Cheers,

tedd
-- 
-------
http://sperling.com  http://ancientstones.com  http://earthstones.com



More information about the talk mailing list