indexing text in databases
Posted 29 August 2006 - 10:27 PM
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/pu...les/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.zen...end.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!
Posted 30 August 2006 - 02:50 PM
Posted 30 August 2006 - 02:57 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users