Speedup Magento
Enable Output Compression:
############################################
## enable apache served files compression
## http://developer.yahoo.com/performance/rules.html#gzip
# Insert filter on all content
SetOutputFilter DEFLATE
# Insert filter on selected content types only
AddOutputFilterByType DEFLATE text/html text/plain text/xml text/css text/javascript application/javascript
# Netscape 4.x has some problems...
BrowserMatch ^Mozilla/4 gzip-only-text/html
# Netscape 4.06-4.08 have some more problems
BrowserMatch ^Mozilla/4\.0[678] no-gzip
# MSIE masquerades as Netscape, but it is fine
BrowserMatch \bMSIE !no-gzip !gzip-only-text/html
# Don't compress images
SetEnvIfNoCase Request_URI \.(?:gif|jpe?g|png)$ no-gzip dont-vary
# Make sure proxies don't deliver the wrong content
Header append Vary User-Agent env=!dont-vary
Disable ETags in .htaccess
############################################
## If running in cluster environment, uncomment this
## http://developer.yahoo.com/performance/rules.html#etags
FileETag none
Merge CSS and Javascript files
Under “Frontend”, change “Use Flat Catalog Category” to YES.
Under “Frontend”, change “Use Flat Catalog Product” to YES. (optional)
Enable the Magento compiler
Log cleaning via admin
1. In the Magento Admin, go to System > Configuration.
2. In the left menu under Advanced, click System.
3. Under “Log Cleaning”, change “Enable Log Cleaning” to “yes” and configure the Save Log for 14 days:
Clean Magento database
You can manually clean up from database by logging in to your Magento database, and truncating the following tables:
log_customer
log_quote
log_summary_type
log_url
log_url_info
log_visitor
log_visitor_info
log_visitor_online