Page 1 of 1

indexing text in databases

Posted: Tue Aug 29, 2006 5:24 pm
by stubarny
Hi,

I'm trying to code a search query for a database of about 500,000 job adverts (similar advert length to monster, careerbuilder etc).

I have found this search code (http://iamcal.com/publish/articles/php/search/) which is suitable for 'small' tables. However at the bottom of the article it mentions that using a FULLTEXT index in mysql would be effective for medium sized databases. I'm assuming that 500,000 adverts is a 'medium' database so I'm thinking this could be a good solution, without having to get to grips with specialist indexing software (e.g. Zend Search Lucene - http://framework.zend.com/manual/en/zend.search.html)

Please can you give me your opinions on whether or not you think simply using a FULLTEXT index is a good solution? (I'm only a 'keen amateur' php/sql programmer so i don't have much experience with the practicalities of running largish databases)

Thanks a lot for your your time!

Stewart

Posted: Tue Aug 29, 2006 5:59 pm
by feyd
Yes, full text indexing is helpful for this application.

Posted: Wed Aug 30, 2006 9:40 am
by stubarny
Thanks, that's great news.

Stu