Hi
What can we do in this situation?"
3 millions is a lot and you'd need a very, very powerful server to cope with that. Note that it's only a problem in the admin, which does complicated databases queries to show you its reports.
Things that can be done to improve situation are:
1 - Delete all 404 URLs. (under 404 URL manager, there's a Purge button - note that I'm
NOT talking about the Purge button on the
SEF URL manager. That would delete all URLs instead of just the 404s.
404s are stored in the same database table, so that could help.
2 - Under the "Advanced" tab of configuration, set "Slow server" to "Yes". This will cause simpler admin reports to be used which may alleviate the problem.
3 - Next steps can only be taken after looking at why you have so many URLs. Where are those URLs coming from? which extension? ECommerce? Directory? are many of those pages obsolete and the content has been removed from the site some times ago?
If you can find such patterns, then you should be able to delete many URLs. Either by hand, or by running MYSQL queries agains the database directly - which requires some expertise though.
NB: if you run some queries to delete URLs directly from the database, make sure to set "Activate URL cache" to "No" under "Advanced" to avoid discrepancies between the file cache and the database content.
4 - Lastly, if nothing else works and not being able to access the SEF URL manager affects your operation, you can use the "Purge" button in the SEF URL toolbar. This is the thermonuclear option, it will delete all
non-custom URLs (any URLs you manually customized will be preserved). All meta data will be preserved as well.
Purging URLs may generate 404s for your visitors while URLs are rebuilt. If you do that, it's best to use a tool such a Screaming From or a 404 link checker to crawl your site just after Purging URLs. By crawling all the pages on your site, those tools will cause the URL database to be created again, minimizing the number of 404s your visitors may face until URLs are rebuilt.
And when we try to access analytics submenu we get error
"Empty list of analytics views, probably using the wrong Analytics account.
If we try to change the date range we get another error "Error fetching analytics reports data (1): No route matched."
could you please point out what might be wrong
Exactly what the messages says: you're likely not using the correct Analytics account for the website you're trying to look at. The Google account used and the UA-xxx analytics id must match the website URL or else the desired report cannot be found.
Best regards
Yannick Gaultier
weeblr.com
@weeblr