Websites Częstochowa - efficient search engine optimization and professional websites programming Częstochowa, Poland. Websites Optimization, positioning, SEO and other services

Database search optimization

Database search optimization - Thumbnail
Online: http://aupair.com

Technologies:
  • MySQL
  • PHP
Work done:
  • 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).

websites 2007 - back