A brief about Openxcell Technolabs •
Openxcell Technolabs is an ISO 9000:2008 certified company located in India and USA
•
We are a team of enthusiastic designers, Developers and managers exceeding the strength of 200
•
We have strong hold in Mobile App Development, Game Development, Web Development, E-commerce Development and Enterprise Systems
•
We have delivered quality solutions to our worldwide clientele
WHY MAGENTO OPTIMIZATION
Why Magento Optimization • Various studies and our own experience shows that the overall performance of Magento is slow • Optimization is required to speed up Magento • Below is a chart showing the research outcomes for Magento performance without optimization
A comparison of Magento performance before optimization and after optimization
WHY DOES PERFORMANCE MATTER?
WHY DOES PERFORMANCE MATTER?
•1 Second delay can cause 7% drop in conversions • Nearly 1/2 of users expect 2 second or less page load time and they tend to abandon if not loaded in 3 seconds •79% of shoppers say they won’t return if performance is poor •44% say they would tell a friend about their poor experience •A Bad Experience Will Drive –46% of users to competitive sites –35% are less likely to visit a problem site on any platform –33% are less likely to purchase from that company • Reference: - http://bit.ly/zVcxsP, http://bit.ly/mHFVVX, http://mz.cm/W5Pkx7, http://bit.ly/xfvPMC, http://bit.ly/yOlHQv
HOW FAST ARE YOU NOW
Google Analytics Site Speed Reports
GT Metrix
WAYS TO OPTIMIZE MAGENTO
Ways to Optimize Magento Challenges & Solutions
• Large number of JAVASCRIPT and CSS • Slow performance due to multiple associated tables • High number of database log tables • Slow performance due to image loading • Improve performance with caching • Cloud Server
LARGE NUMBER OF JAVASCRIPT & CSS
Large number of JAVASCRIPT & CSS • Large number of JAVASCRIPT and CSS creates higher no. of HTTP request. • Response time will go on a higher side because of higher no. of HTTP request and system will be slow.
Solution Merge CSS and JAVASCRIPT files into single file: •
In the Magento Admin, go to System > Configuration > Developer.
•
Under "Javascript Settings", change "Merge Javascript Files" to YES.
•
Under "CSS Settings", change "Merge CSS Files" to YES.
•
Clear the cache.
Solution
SLOW PERFORMANCE DUE TO MULTIPLE ASSOCIATED TABLES
Slow performance due to multiple associated tables •
One of the main issues with Magento sites running slowly, is a database that has become large and difficult to use for sending/retrieving data from.
•
The model Magento uses to store customer and product data results in longer than average SQL queries and more reads.
•
Enabling the Flat Catalog option for Categories and Products will merge product data into one table, therefore improving performance.
Solution Enabling Fat Catalog: •
Login to administration area and go to - System > Configuration > Catalog
•
Under "Frontend", change "Use Flat Catalog Category" to yes
•
Under "Frontend", change "Use Flat Catalog Product" to yes
•
Clear your Magento cache
HIGH NUMBER OF DATABASE LOG TABLES
High number of database log tables • Higher number of database logs creates higher response time in system • Below is the table that are populated due to logging feature of Magento
Solution Database log cleaning using Magento administration •
In Magento administration go to System > Configuration
•
In the left menu under Advanced click on System
•
Under "Log Cleaning", change "Enable Log Cleaning" to YES and configure the Save Log days as per your requirement
•
Click "Save Config"
SLOW PERFORMANCE DUE TO IMAGE LOADING
Slow performance due to image loading •
There are large number of images in any ecommerce store.
•
On an average a product has more than 3 images and number of products can be unlimited.
•
So its very necessary to optimize the images used in Magento store.
•
Optimization of images prevents the system from higher response time.
•
Choose the correct format for the image - JPG, GIF, PNG8, PNG24
•
JPG is great for photographic images
•
GIF largely replaced by PNGs, but still sometimes a viable option for small patterns and textures
•
PNG combines some of the best qualities of both and with PNG24 supports true transparency
IMPROVE PERFORMANCE WITH CACHING
Improve performance with caching •
Setup your admin for maximum performance.
•
These are the settings that will significantly speed up your Magento installation: Navigate to System > Cache Management and enable all cache types
•
Below is the default caching provided by Magento
•
Enabling caching option that Magento provides is not enough
•
So we need to use 3rd party caching extension for full page caching
•
Example: Nitrogento (http://www.nitrogento.com/) First install the extension
Drawback of using full page caching : Enabling caching of every block with nitrogento causes different issues as below• Caching of Price block shows incorrect price for various products • Wrong data in checkout processes
Implement Varnish • Why Varnish – HTTP Accelerator – Caching reverse proxy – Load Balancer – Fail over system
Before & After Before Varnish
After Varnish
Extension Required : Turpentine- Varnish Cache http://www.magentocommerce.com/magento-connect/turpentine-6332.html
Install and Configure Varnish •
Add the Repository
•
Install the Package
•
Configure the Daemon
•
Service nginx restart
•
Service php5 - fpm restart
•
Service Varnish restart
•
Varnish Start
•
Please follow the below link for detail understanding of the process. http://todsul.com/tech/install-and-configure-varnish-with-nginx/
AMAZON CLOUD SERVER
Cloud Server
The most important Amazon services for Magento hosting •
Amazon Elastic Compute Cloud (EC2)
•
Auto Scaling
•
Elastic Load Balancing
•
Amazon CloudFront (CDN)
•
Amazon Relational Database Services (RDS)
•
Amazon Route 53
•
Amazon ElastCache
•
Amazon Simple Storage Services (Amazon S3)
Benefits of Amazon cloud server: •
Flexibility
•
Deployment Speed
•
Performance
•
Increase in capacity to accommodate higher number of visitors
•
Better conversion rate
•
Lower hosting cost through improve hardware efficiency