Essay On Flat Table

823 Words4 Pages
Using flat tables means that you are not affecting any other things but only the speed of the site for your customers. Make sure to test the flat tables on the development site before making the changings in productions as many of the extensions do not work well with these flat tables. The configuration of Flat Tables: The below mentioned are the tips and tricks to configure the flat tables in your database: Go to System > Configuration Select Catalog from left Open the Front End Change the option to Yes of the Use Flat Catalog Category and Use Flat Catalog Product Hit Save and don’t forget to Test Asset Crushing: Magento depends on quite a few CSS and Javascript files in order to run, further you can add extensions as well. On the web,…show more content…
You might think about data loss. Not to worry Magento’s database logs are not used for much. Cleaning Database Logs: The below mentioned are the tips and tricks to configure the database log cleaning: Go to System > Configuration Click on the link on the left bottom named System Open up the Log panel Set the following settings Set Enable Log to Yes Set Save Log, Days to 7 Set Enable Log Cleaning to Yes Set Start Time to 0:00:00 Set Frequency to Daily Enter your email address at Error Email Recipient Hit Save and don’t forget to Test. The Alternative Is Here! Disable Database Logs: Yes, we have here a golden option too. This alternative is here to remove the additional functionalities of your website, let’s suppose you don’t need the functionalities of Recently Viewed Product or Compare Products for not logged in customers then simply just disable these logs. In result, you will get a Webstore which is much faster than before and yes your logs will be clean. To do this, the steps are mentioned below: Go to System > Configuration Click on the link on the left bottom named System Open up the Log panel Set Enable Log to No Hit Save and don’t forget to Test. Disable the Error/Debug Message Logging: This is the last option in the list and can be done only if you have resolved all the errors on the site. Still, it can be useful to catch rare errors that are not discovered yet by keeping the logging enabled. But if you
Get Access