- Enable Flat Catalog (Categories and Products)
Navigate to “Stores” → “Configuration” → “Catalog.” (main page) Frontend. Set “Use Flat Catalog Category” and “Use Flat Catalog Product” to “Yes“.
Now Click on “Save Config.” will put all attributes in one table for Magento to retrieve.By default the attributes that apply to Categories and Products are stored in separate database tables. This change will make query simple hence the site speed especially if it has more products.
- Concatenate (merge) CSS and Javascript Files
System > Configuration, (left nav) Advanced > Developer, (main page) JavaScript Settings, CSS Settings. Set “Merge Javascript” Files and “Merge CSS” Files to “Yes”.
This action will combine all CSS and javascript into one file which will make page load faster.
- Enable Compilation
- Navigate to “System” → “Tools” → “Compilation.”
- Click on “Run Compilation Process.”
Note:Dont forget to disable compilation whenever you want to change code or install extension or else you will get errors
- Clean Up Magento Database & Logs
- Navigate to “System” → “Configuration” → “Advanced”→ “System” → “Log Cleaning”
- Under “Save Log, Days” change it to 20 days, or whatever you prefer.( By default its 180 days
- Click on “Save Config.”
- Fewer Extensions & Modules
- Installing lot of extensions and modules make application heavy as a result hampers the performance.
- Image Optimization
- This the major area which impacts the performance.60% or the performance can be improved by uploading light weight images .having proper files types etc.
- MySQL Configuration
- Update Indexes
- When ever you do any change to application you should perform the re indexing.It improves performance a lot .
- Caching Magento
- Magneto provides very good feature which creates and stores the cache at server side so that it doesnt need to compile everything on each user request .
- You should always refresh your cache after doing changes .When all the settings are in place and the site is ready to go live, go to System > Cache Management. Select all items, set the Action dropdown to “Enable” then hit Submit
I have shared most of the things which a layman can do .A developer can do much more .I will discuss the same in any other post.
