Last active
September 29, 2015 11:40
-
-
Save bluemyria/140e0c52f09e468b3e77 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Performance : Optimization of slow pages (various tasks under EPIC "performance" and more) | |
| 1. QUERY performance | |
| enabled Query Log (/admin/config/development/devel) - visit/identify pages with slow queries | |
| EXPLAIN the queries - http://cyrve.com/explain | |
| possible fixes | |
| -> add Indexes | |
| -> remove unecessary JOINs | |
| -> minimise the item it has to sort | |
| -> last resort - caching | |
| caching strategies | |
| -> examples : | |
| frontpage - see SOL-542 | |
| /community (messages-mainview - sort from from timestamp -> nid) | |
| /community most liked image | |
| 2. RENDERing performance | |
| XHprof |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment