to index or not

From: 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.

« previous php.db (#8964) next »