to index or not
| From: | Selvin Sakal | Date: | Sun, 29 Apr 2001 09:49:25 +0000 |
| Subject: | to index or not | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-8964@lists.php.net to get a copy of this message | ||
i'm makin a search engine the table looks like this -
-------------------------------------------------------
| number | name | keywords | description | url | rank |
-------------------------------------------------------
query's are made to against keywords, and description which are a blob's. I want to index both of them but i don't know if i should use php index function to create the index or make one myself which could look like this
-------------
word | site |
-------------
site would contain the number's of the row which have the queryed word in their keyword or description.
can some tell which way is faster or is there no difference and can someone tell me a better way if there is any and also any possible idea's on the php script required to ran a query for words
thanks
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.