Please excuse my ignorance (i am not very familar with mysql) but why does vb have to have a search index?
Why would we not just do a "SELECT * from thread where pagetext LIKE $searchterms" or something like that?
I am assuming this has something to do with perfomance, but I cant understand why its better to search thru the index than the post itsself.
Thanks in advance
Why would we not just do a "SELECT * from thread where pagetext LIKE $searchterms" or something like that?
I am assuming this has something to do with perfomance, but I cant understand why its better to search thru the index than the post itsself.
Thanks in advance
Comment