phpmysqlsoundex

Is it better to use PHP or MySQL for Soundex queries?

I am just wondering whether it would be better to use PHP's Soundex Function or MySQL's Soundex Function?

Also do the PHP and MySQL Soundex function produce the same results?

Solution

  • This is an ancient debate in web application design. It all depends. Some people like to store business logic only in the PHP code and just use databases for storage. Others say the overhead required for PHP isn't worth it on massive CRUD operations. It really comes down to preference.