I have a Magento site, It's backend is very slow.
We have APC installed. Then also it is very slow.
How to make it faster?
We have AheadWorks followup extension installed. The Email log contains nearly 100K records. That email log takes 10mins to load in the backend. Our stack holders don't want to cleanup the records.
Any way out to make the backend faster??
Thanks in advance.
Can the server hardware handle the huge number of records in your email log? Installing APC will notmiraculously improve the loading speed especially for the backend if you have a lot of records and the server cannot keep up.
please provide more technical details,
and what response you got from AheadWorks? etc
Not sure why APC is not working up to the mark,
There are few things which you can consider.
1. Hosting Provider
2. Database cleanup (https://docs.nexcess.net/article/magento-database-maintenance.html)
3. Using FPC extension (we have also developed our own)
4. Perform other optimization tips, https://docs.nexcess.net/article/optimizing-magento-performance.html
I would suggest that you take a loo at Magento White Papers before trying any other optimize extension as this should not be necessary if your server and installation is done right.
This might be diffucult to understand, but its wurth your time reading, then you see different kind of solution regarding if the bottleneck is with the DB, Page it self or Server.
In anyway using a extension to get a page to work better in performence would only make the Webpage to handle one or more task.. and can also then do the page more slower.
if you are using php-fpm then you can enable the slow log and also mysql-slow log to see which call taking too much time.
Also check the php error log and exception log in magento. Sometimes it could be because of a background slow webservice call.
Also its always adviced to clean up log tables periodically and also archive you logs.
If this doesn't helps, please provide how many skus are there in your installation, where are you storing sessions etc.
Hi @Girish SH
You can run mysql query to clean up your site
TRUNCATE `log_customer`; TRUNCATE `log_quote`; TRUNCATE `log_summary`; TRUNCATE `log_summary_type`; TRUNCATE `log_url`; TRUNCATE `log_url_info`; TRUNCATE `log_visitor`; TRUNCATE `log_visitor_info`; TRUNCATE `log_visitor_online`; TRUNCATE `core_session`;
You can use clean up script to clean your store: bitbucket.org/snippets/magegiant/dB4j
Its really improved peformace of my magento store.