Categories


Archives


Recent Posts


Categories


SQL Headquarters

astorm

Frustrated by Magento? Then you’ll love Commerce Bug, the must have debugging extension for anyone using Magento. Whether you’re just starting out or you’re a seasoned pro, Commerce Bug will save you and your team hours everyday. Grab a copy and start working with Magento instead of against it.

No Frills Magento Layout is the only Magento front end book you'll ever need. Get your copy today!

There’s more sophisticated ways of logging and profiling SQL in Magento these days, but sometimes it’s still easier and quicker to drop down to the abstract Zend adapter and log your queries with a few discrete calls to Mage::Log

Almost every INSERT, UPDATE, SELECT, and DELETE goes through the methods in

lib/Zend/Db/Adapter/Abstract.php

Remember to clean up after yourself!

Copyright © Alan Storm 1975 – 2017 All Rights Reserved

Originally Posted: 21st June 2011