WARNING - not all information at this site is up to date. I am working on new version of this site.
Database search optimization
Online: http://aupair.com
Technologies:
Technologies:
- MySQL
- PHP
- search system analysis
- database analysis
- MySQL nad PHP programming
- new search system testing
My task was shortening time of website searching amongst several dozen records as much as possible. Analysis of database and PHP code gave reason of long searching (in some cases over 2 minutes).
Improving search system meant rebuilding way of searching among meny record (PHP programming) and also creating indexes on proper columns in database. Those actions brought huge improvement of search time (in worst cases from 2 minutes to about 2-3 seconds).