News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Wolfgang Drews' Blog:
Some thoughts on indexes & searching in MySQL / PHP
June 05, 2006 @ 06:03:05

Giving your users a tool to find relevant invormation from the vast ocean that is the content of your site isn't easy sometimes. Even with the powerful combination of PHP and MySQL, it can be difficult to find what you're looking for. Wolfgang Drews shares in some of this frustration in his new blog post.

Using MySQL most of you will be familiar with this: searching in textfields for keywords is quite uncomfortable when using other table handler then MyISAM. If you use MyISAM, you can utilise the Fulltext-Search with MATCH AGAINST. Otherwise you are thrown back to "simple" string comparison functions (LIKE). Not really satisfying. As this won't change with the 5.1er Version of MySQL, i have to search for another solution.

His other suggestions include the use of two other tables (terms in one, references back to content in another) or an external search option, such as the Zend Framework's implementation of the lucene functionality - Zend_Search.

1 comment voice your opinion now!
search mysql fulltext like lucene zend framework search mysql fulltext like lucene zend framework


blog comments powered by Disqus

Similar Posts

Paul Jones' Blog: Solar 0.20.0 released

Andi Gutmans\' Blog: New Zend Framework Website look launched (almost)

DevShed: Creating the Admin Script for a PHP/MySQL Blogging System (Part 3)

Jim Plush\'s Blog: MyBic AJAX/PHP framework in top 1% of SourceForge projects in 4 days!

JSLabs Blog: Top 10 PHP frameworks (for 11.28.2006)


Community Events





Don't see your event here?
Let us know!


refactor series opinion laravel introduction interview testing code list wordpress unittest release install developer threedevsandamaybe language podcast framework community experience

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework