|All requests||>||What is the best PHP mysql index opti...||>||Request new recommendation||>||Featured requests||>||No recommendations|
by Ronald Stevens - 2 years ago (2016-11-11)
Not a problem, but is good knowledge.
The more speed you get out of this bottle neck the better it is.
1. by Oleg Zorin - 2 years ago (2016-11-15) Reply
Good day, Ronald.
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.
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).
Smarty could helps you.
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.
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.