Openxcell conducts a successful webinar on Magento Optimization

1
(No Transcript)
2
A brief about Openxcell Technolabs

• Openxcell Technolabs is an ISO 90002008
  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

3
WHY MAGENTO OPTIMIZATION
4
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

5
A comparison of Magento performance before
optimization and after optimization
6
WHY DOES PERFORMANCE MATTER?
7
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 wont 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

8
HOW FAST ARE YOU NOW
9
Google Analytics Site Speed Reports
10
GT Metrix
11
WAYS TO OPTIMIZE MAGENTO
12
Ways to Optimize MagentoChallenges 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

13
LARGE NUMBER OF JAVASCRIPT CSS
14
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.

15
Solution

• Merge CSS and JAVASCRIPT files into single file
• In the Magento Admin, go to System gt
  Configuration gt Developer.
• Under "Javascript Settings", change "Merge
  Javascript Files" to YES.
• Under "CSS Settings", change "Merge CSS Files" to
  YES.
• Clear the cache.

16
Solution
17
SLOW PERFORMANCE DUE TO MULTIPLE ASSOCIATED TABLES
18
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.

19
Solution

• Enabling Fat Catalog
• Login to administration area and go to -
  System gt Configuration gt Catalog
• Under "Frontend", change "Use Flat Catalog
  Category" to yes
• Under "Frontend", change "Use Flat Catalog
  Product" to yes
• Clear your Magento cache

20
(No Transcript)
21
HIGH NUMBER OF DATABASE LOG TABLES
22
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

23
Solution

• Database log cleaning using Magento
  administration
• In Magento administration go to System gt
  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"

24
SLOW PERFORMANCE DUE TO IMAGE LOADING
25
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.

26

• 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

27
IMPROVE PERFORMANCE WITH CACHING
28
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 gt Cache Management and enable all cache
  types
• Below is the default caching provided by Magento

29

• 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

30

• 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

31
Implement Varnish

• Why Varnish
• HTTP Accelerator
• Caching reverse proxy
• Load Balancer
• Fail over system

32
Before After
Before Varnish
After Varnish
33
Extension Required Turpentine- Varnish Cache
http//www.magentocommerce.com/magento-connect/tur
pentine-6332.html
34
(No Transcript)
35
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-varn
  ish-with-nginx/

36
AMAZON CLOUD SERVER
37
Cloud ServerThe 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)

38
(No Transcript)
39
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

40
(No Transcript)