Tag » Posts Tagged ‘Optimize’

How to move the JS file includes to footer in Magento


In order to reduce the initial load time of page, it is recommended to move all the JS includes in the <head> section of web page to the footer. Lets see how we can do it in Magento.

Step 1: Add Layout Updates

Create a child block of “before_body_end” named “foot” similar to the head block in local.xml file as shown below:

<?xml version="1.0" ?>
<layout version="0.1.0">
<reference name="before_body_end">
<block type="page/html_head" name="foot" as="foot" after="-" template="page/html/foot.phtml"/>

Continue reading »

How to enable “Magento Profiler” and use it to identify Magento Performance bottlenecks

Optimize Performance

Magneto comes with a very useful debugging tool for developers called “Profiler”. It can be used to identify issues in your code making the website slow. The Magento “Profiler” reports the time taken by block of code under test to execute, the number of times the block of code executed and the memory used by it while rendering a Magento web page.

By default Magento Profiler is disabled, let see how to enable it.

How to enable “Profiler” in Magento?

To enable “Profiler” in Magento, you have to go through 2 parts:

Part A

1) Go to Admin >> System >> Configuration.

2) Under the “Advanced” tab, click the “Developer” link to open the developer section.

3) Now expand the “Debug” block and select “Yes” in the Profiler dropdown.

4) If you are debugging in a live environment then its better to restrict the profiler output display to the developers only so that customers browsing your website do not see any differences on the frontend. To do so expand the “Developer Client Restrictions” block and add the developer IPs comma separated in the text box provided.

5) Save the configuration.

Continue reading »

How to Optimize a MySQL Database using phpMyAdmin?


Optimizing Table in database is just like the doing Disk Defragmentation in your PC.

Optimize Table should be used if you have deleted a large part of a table or if you have made many changes to a table with variable length rows, such as VARCHAR, TEXT, BLOB or VARBINARY columns. Deleted rows are maintained in the linked list and insert operations reuse the old row positions. You can use “Optimize Table” to reclaim unused space and defragment the data file for optimal performance. If a lot of changes have been made to a table, optimizing the table can sometimes significantly improve performance.

Continue reading »

Clean up Magento database logs for Faster Performance

Database Optimization

Magento maintains several log tables for tracking purpose like customer access, products viewed, products compared etc. These tables grow in size day by day so if you have a large numbers of visitors on your website the size of these log tables may become large enough within a week slowing down your database. So you should perform database log cleaning on a regular basis – daily/weekly/monthly depending upon your website traffic.

There are three ways to clean out these tables:

1. Log Cleaning in the Magento Admin

2. Shell Utility log.php in the ../shell directory, and

3. Manually via phpMyAdmin or mysql client

Continue reading »

Back to top