indexing text in databases

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
stubarny
Forum Newbie
Posts: 10
Joined: Thu Jul 27, 2006 12:53 pm

indexing text in databases

Post 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Yes, full text indexing is helpful for this application.
stubarny
Forum Newbie
Posts: 10
Joined: Thu Jul 27, 2006 12:53 pm

Post by stubarny »

Thanks, that's great news.

Stu
Post Reply