Static blocks are a means of allowing store owners to modify the text displayed in sections of a page from the admin site. For example, a static block can be added to the header to show seasonal promotions. Static blocks can be added to templates through the use of layout files. Adding a static block … Continue reading Adding a static block to a template using layout files

In the last article we saw the different ways how one can analyse the SQL Queries running under the Magento’s hood. These are listed here again: To see all queries issued to the database Modify the core Magento code that deals with the database query generation Enable Magento Pdo MySql debugging Switch on MySQL logging … Continue reading Magento SQL Logging – (Part II)

As with any e-commerce solution Magento stores nearly all the data of the online store in a database. To simplify the communication between code and the database Magento provides a number of abstraction functions. The use of abstraction to communicate with the database leads to the question of what queries are being issued to the … Continue reading Magento SQL Logging – (Part I)