Improved Performance for Searching

Bhullarz's Avatar
Skilled contributor
Hi ! How can we improve the speed of searching where we are using MySQL database with PHP 5.? Can somebody explain with example a small search code in PHP-MySQL ?
Thanks in advance.
asha's Avatar, Join Date: Nov 2006
Go4Expert Member
Query speed is directly related to table design and indexes, if you want fast text searching try the 3rd party MySQL engine Sphinx.