PHP Classes
elePHPant
Icontem

What is the best PHP mysql index optimization class?: How to figure how to optimize MySQL table indexes

Recommend this page to a friend!
  All requests RSS feed  >  What is the best PHP mysql index opti...  >  Request new recommendation  >  A request is featured when there is no good recommended package on the site when it is posted. Featured requests  >  No recommendations No recommendations  

What is the best PHP mysql index optimization class?

A request is featured when there is no good recommended package on the site when it is posted. Edit

by Ronald Stevens - 2 years ago (2016-11-11)

How to figure how to optimize MySQL table indexes

This request is clear and relevant.
This request is not clear or is not relevant.

+2

Not a problem, but is good knowledge.

The more speed you get out of this bottle neck the better it is.

  • 1 Clarification request
  • 1. by Oleg Zorin - 2 years ago (2016-11-15) Reply

    Good day, Ronald.

    1. Watch Manuel's tips and tricks: https://www.launchclasses.com/MySQL-Index-Optimization-Tips-1 https://www.launchclasses.com/MySQL-Index-Optimization-Tips-2

    Page optimization (chipest first): 2. Log your sql requests. Check if equal request exists during one page generation.

    In most cases, several requsts to user table are present. Try to make only one request if possible.

    1. Use cache for requsts of most "popular" data from DB.

    As usual cache could be used for products data or users data (if there are no frequent updates).

    Use memchech or redis (or somthing else).

    1. Use cache of part or entire HTML.

    Smarty could helps you.

    1. Replicate or/and shard your DB.
    2. Use search engines.

    Search engines could help you if your application uses complex requests (facet request).

    Tyr Apache Solr - it's free and powerful. I have use it in my shop for products facet search by set of params.

    1. Use CDN.

    Your can maintain your own CDN, but, I think, it's more better to use CDN as a service.

    • 2. by Manuel Lemos - 2 years ago (2016-12-06) in reply to comment 1 by Oleg Zorin Comment

      As Oleg mentioned there is video and an article precisely about this topic.

      It would be cool if there was a class that could for instance use the EXPLAIN SQL command and suggestion index changes to optimize your queries.

Ask clarification

Recommend package
: 
: