Magento is the most used eCommerce platform out there used by millions of shopping carts on the Internet today. Since there are so many shopping carts available the customer experience should be greater to attract them to buy on your website. Beside the website look and feel, one of the important parts of the customer experience is the website loading speed. As long as it takes to load a website as much the possibility to lose a customer raise. Do not let this happen and boost Magento speed and performance should be one of your priorities.
Boosting your Magento website speed should be the job of your web developer, but not all web developers are taking care about this. On a slow site speed not only that you will lose customers but you might lose new customer acquiring because Google is incorporating the page speed into its rankings.
if you think that your Magento website is running slow you should try to implement below easier tips to boost Magento speed and performance.
Clean Magento Database logs
Enable flat categories and products
Activate Magento Cache
Combine (merge) JS/CSS
enatble Magento compilation
Config Magento Logs

Clean Magento database logs

Magento rich features makes it to be one of the best shopping cart platform, but in order to achieve this, the Magento developers must been forgot to optimize the database. On big stores, the database is very big and the latency of query execution is high.You can gain a better performance by clearing database logs.

The first method that you can use to clean your logs is to tune settings from your Magento administration panel:

  1. Log in into your Magento admin and go to SystemConfiguration.
  2. In the left Advanced menu click on System.
  3. Under Log Cleaning change Enable log clearing to “Yes” and configure the Save Log. Days to the period that you want. We recommend to keep the log for no more than 5 days:Magento Admin Log Cleaning
  4. Click on Save Config on the upper right corner.

The second way is the more efficient way to clear the logs directly from phpMyAdmin using build-in features to empty tables or by running SQL scripts. Is more efficient than the first one because Magento cleanup tool because you can empty some extra tables.

On your phpMyAdmin open the Magento database and on the right list select the following tables:

dataflow_batch_export
dataflow_batch_import
log_customer
log_quote
log_summary
log_summary_type
log_url
log_url_info
log_visitor
log_visitor_info
log_visitor_online
report_viewed_product_index
report_compared_product_index
report_event

 

At the bottom of the page click on the drop-down box “With Selected:” and select “Empty“. Click Yes on confirmation box and all above tables will be emptied.

You can also run the following SQL script to truncate tables:

TRUNCATE dataflow_batch_export;
TRUNCATE dataflow_batch_import;
TRUNCATE log_customer;
TRUNCATE log_quote;
TRUNCATE log_summary;
TRUNCATE log_summary_type;
TRUNCATE log_url;
TRUNCATE log_url_info;
TRUNCATE log_visitor;
TRUNCATE log_visitor_info;
TRUNCATE log_visitor_online;
TRUNCATE report_viewed_product_index;
TRUNCATE report_compared_product_index;
TRUNCATE report_event;

Please make sure that you prepared a backup before if anything goes wrong.

Enable Magento flat categories and products

The Magento database structure is a large one and, for example, to retrieve information about a product or category the system should query the database and get information form multiple tables growing the sql execution time. You can avoid this by enable flat categories and products from administration panel. These features will take the information available in multiple tables and merge into one table (or a considerably low number of tables) reducing the retrieving response time and boost Magento speed.

To enable flat categories and products on your Magento store you should follow the steps:

  1. Log in into your Magento admin and go to SystemConfiguration.
  2. In the left Catalog menu click on Catalog link.
  3. Set Use Flat Catalog Category and Use Flat Catalog Product to Yes:Enable Magento Flat Categories and Products
  4. Click on Save Config on the upper right corner.

After updating to Flat category and products you need to Re-index the data from the Magento Index Management.

Enable all Magento caches

Magento caching is one of the fastest ways to boost Magento speed. By enabling cache you ensure that you will send to your visitor a saved result of the original page loaded before without the necessity to load it again.

To activate your Magento cache:

  1. Log in into your Magento admin and go to SystemCache Management.
  2. Check all caches, select “Enable” from Actions and press Submit:Enable Magento Cache

Enable Magento compilation

Magento compilation refers to concatenation of PHP files into single file and store into single location which is includes/src. By doing this Magento increases the loading time because when a class is loaded into a PHP file,  Magento Autoloader looks in four locations for the file. No compilation is useful if you want to modify core files, but boost Magento speed because instead searching into multiple directories, the system will know exactly where the file is.

To activate Magento compilation you should:

  1. Log in into your Magento admin and go to SystemToolsCompilation.
  2. View current status of Magento Compilation tool.
  3. if Compiler Status is disabled, click on Run compilation process.

Conclusion

You Magento store is a everything that you need to run a successful online business but not only the features included in a website can make it grow. Consider boosting your Magento website speed with priority and don’t be afraid that you will damage something. And even if you will, you keep daily backup for your website, don’t you?

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

clear formSubmit