i found a nice tips to improve db performance & save some db space, by disabling Magento logs & report
here the local.xml settings
<?xml version="1.0"?> <!-- license --> <config> <global> <!-- global config --> </global> <frontend> <events> <!-- disble logs --> <controller_action_predispatch> <observers><log><type>disabled</type></log></observers> </controller_action_predispatch> <controller_action_postdispatch> <observers><log><type>disabled</type></log></observers> </controller_action_postdispatch> <customer_login> <observers><log><type>disabled</type></log></observers> </customer_login> <customer_logout> <observers><log><type>disabled</type></log></observers> </customer_logout> <sales_quote_save_after> <observers><log><type>disabled</type></log></observers> </sales_quote_save_after> <checkout_quote_destroy> <observers><log><type>disabled</type></log></observers> </checkout_quote_destroy> <!-- disable reports --> <catalog_controller_product_view> <observers><reports><type>disabled</type></reports></observers> </catalog_controller_product_view> <catalog_product_compare_add_product> <observers><reports><type>disabled</type></reports></observers> </catalog_product_compare_add_product> <catalog_product_compare_item_collection_clear> <observers><reports><type>disabled</type></reports></observers> </catalog_product_compare_item_collection_clear> <catalog_product_compare_remove_product> <observers><reports><type>disabled</type></reports></observers> </catalog_product_compare_remove_product> <customer_logout> <observers><reports><type>disabled</type></reports></observers> </customer_logout> <sales_quote_item_save_before> <observers><reports><type>disabled</type></reports></observers> </sales_quote_item_save_before> <sendfriend_product> <observers><reports><type>disabled</type></reports></observers> </sendfriend_product> <wishlist_add_product> <observers><reports><type>disabled</type></reports></observers> </wishlist_add_product> <wishlist_share> <observers><reports><type>disabled</type></reports></observers> </wishlist_share> </events> </frontend> </config>
i found this from this link
https://gist.github.com/MikeWilkie/10555056
there is another tips regarding this, you can check this out on this page
Magento Speed Tip: Disabling Database Logging
Comments are closed.