Magento Optimization

Magento Optimization

Magento is a very popular eCommerce.

We offer several suggestions for optimizing this popular CMS.

Note: Magento consumes significantly more resources than other eCommerce s.

And if you have a problem with resource hosting, you must think about a dedicated server.

Also, keep in mind that VPS is not a good solution for popular Magento websites.

Because most VPSs give you fewer resources than what you bought.

Changes to .htaccess

Enable Output Compression

If you have a .htaccess file. To have your own Magento website, you need to find the part of the text with

& lt; IfModule mod_deflate.c & gt; Starts and ends with & lt; / IfModule & gt; LT is.

This section can turn on Apache’s mod_deflate module, which provides compression for text, java, and CSS.

You can uncomment this part.

Like the code line below

<IfModule mod_deflate.c>

############################################
## enable apache served files compression
## http://developer.yahoo.com/performance/rules.html#gzip

     # Insert filter on all content
     SetOutputFilter DEFLATE
     # Insert filter on selected content types only
     AddOutputFilterByType DEFLATE text/html text/plain text/xml
text/css text/javascript

     # Netscape 4.x has some problems...
     BrowserMatch ^Mozilla/4 gzip-only-text/html

     # Netscape 4.06-4.08 have some more problems
     BrowserMatch ^Mozilla/4\.0[678] no-gzip

     # MSIE masquerades as Netscape, but it is fine
     BrowserMatch \bMSIE !no-gzip !gzip-only-text/html

     # Don't compress images
     SetEnvIfNoCase Request_URI \.(?:gif|jpe?g|png)$ no-gzip dont-vary

     # Make sure proxies don't deliver the wrong content
     Header append Vary User-Agent env=!dont-vary

</IfModule>

Enable Expires Headers

Visitors who open your website for the first time send multiple HTTP requests

Using the “Expires” header, you cache site components.

This will reduce unnecessary HTTP requests on your server.

To do this you need to find the .htaccess file. Where with the phrase & lt; IfModule mod_expires.c & gt; begins

And with the phrase & lt; / IfModule & gt; It ends

<IfModule mod_expires.c>

############################################
## Add default Expires header
## http://developer.yahoo.com/performance/rules.html#expires

     ExpiresActive On
     ExpiresDefault "access plus 1 year"

</IfModule>

Magento Administration Tweaks

Merge CSS and JS

This particular trick reduces the number of HTTP requests on your website.

If your Magento version is x1.4.x or earlier, you can use the free Fooman_Speedster extension.

If you are using later versions, follow these steps.

1. Enter the admin menu and go to System & gt; Configuration & gt; Developer.
2. In the “JavaScript Settings” section, change “Merge JavaScript Files” to Yes.
3. In “CSS Settings,” change “Merge CSS Files” to Yes.
4. Finally, you need to clear your Magento cache.

Enabling Flat Catalog

By activating the Flat Catalog feature for Categories and Products, you save the Product data in a table.

And in this way, you reduce database queries, which results in better performance.

1. Perform the following steps to do this.
2. Enter the admin panel and go to System & gt; Configuration & gt; Catalog.
3. Change “Use Flat Catalog Category” to “Yes” from the “Frontend” section.
4. Change “Use Flat Catalog Product” from “Frontend” to Yes, which is optional.
5. Finally, you need to clear your Magento cache.

Database Maintenance Tips

The main problem that Magento websites slow down is the large size of the database.

This large size of the database slows down the sending and receiving of data from the database.

Below we offer you several tricks to reduce the size of the database.

Database Logs

There are several tables that Magento uses for logging.

Because log files are so important and almost every request is saved, log files grow quickly.

So maintaining these files can go a long way in improving the speed of our site.

Below you can see the tables related to logging.

& nbsp;

 log_customer
log_visitor
log_visitor_info
log_url
log_url_info
log_quote
report_viewed_product_index
report_compared_product_index
report_event
catalog_compare_item 

Database Log Cleaning using Magento Administration

1. in Magento admin to System & gt; Go to Configuration
2. Click system from the left menu and Advanced section.
3. From “Log Cleaning,” change “Enable Log Cleaning” to Yes and configure the log file for 14 days.
4. Click Save Config.

log.php Utility

Magento provides a shell tool configured through the corn or runs manually to clear log files.

Manually

Log in to your account with SSH and go to the Magento root directory and then type:

php -f shell / log.php clean

You can also use the -days switch to specify how many days you want to save.

Cron

1. Log in to C Panel
2. Click on corn job

This is just an example:

php -f
/home/yourcpanelusername/public_html/path/to/magento/shell/log.php


Database Cleaning via phpMyAdmin

Use phpMyAdmin, which helps you a lot and has a lot of flexibility

1. Log in to C Panel and click on phpMyAdmin
2. Click on the database where you installed Magento.
3. Select the following tables

 log_customer
log_quote
log_summary
log_summary_type
log_url
log_url_info
log_visitor
log_visitor_info
log_visitor_online

Finally, click on the drop-down menu and select Empty; at this moment, a confirmation will be sent to you to click Yes.