4. Enable Magento Flat Catalog
Magento inherently uses the EAV database module. This means that each product or category has information spread throughout dozens of tables. Every time that a product page is requested or a category page is requested a big join query is made to gather all these pieces of information and build the product object. While extremely flexible this feature is a huge bottleneck for performance – this is where the flat catalog comes handy. The flat catalog essentially allows Magento to build the same objects with one single DB query from one single DB table.
To turn this feature on, go in the Magento Admin Panel to “System” > “Configuration”, choose “Catalog” from the “Catalog” panel. Expand the top panel which should say “Frontend” and at the bottom you should see two options “Use Flat Catalog Product” and “Use Flat Catalog Category”. Set both to Yes.
Note: if these options are grayed out, you probably need to enable indexing for these features (In the “System” > “Index Management” page).
5. Avoid Using Layered Navigation if You Don’t Need It
Layered Navigation is actually a great feature for shopping carts with a large catalog. It helps your users find the right product by narrowing down the product attributes it wishes to buy. These feature unfortunately slows down Magento significantly, hence if you do not use it or understand what it is, go ahead and disable it until you are ready.
In order to disable this feature, set the attribute ‘Anchor Category’ to ‘No’ for all your categories.
6. Extend Minimally: Only Install Extensions You Need
This tip is trivial, but I often see this mistake been made by existing store owners. To install a new Magento extension is so easy these days, that many simply go for it and try out a variety of extensions. The problem is that the vast majority of these extensions may not be programmed with performance in mind, hence they are a hindrance on the site performance. Even worst, some extensions may introduce security wholes that you may never know about until it is too late. Hence, it is always a safe practice to use as little extensions as you need and never leave any extension just because you never had the time to remove it. Less extensions also means easier upgrades, which is my next performance tip.
7. Use the Latest Stable Edition & Update Often
Another trivial performance tip that many store owners skip for the sake of adding features or lack of resources is upgrading often. Magento is still in its infancy as a shopping cart platform and there are tons of features that are now being discussed and added into the core code. In the last 12 months the Magento Core team has been putting a lot of effort in closing bugs and adding performance enhancements, like the flat catalogs, caching & indexing mechanisms, and now the compilation mechanism. So, if there is a new stable version available out there you should focus on upgrading your core platform and learn in what new ways you will be able to boost performance, and most importantly sales!