We have a website that has around 80k users per month and we're updating around 1k entries per night due to stock updates. The site's been live for almost 2 years and the CMS has become really slow and almost unworkable. The front-end seems pretty good due to cache but slow without it.
After doing some digging, I noticed the table 'elements_sites' in phpMyAdmin has 1.45m rows. with all but 9k of these showing a NULL slug and uri. It seems like its got loads of 'junk' in there but I don't fully understand it. The 'elements' table has 486k rows, 'content' has 466k rows.
Here's what I'm trying to figure out so any pointers would be great.
- Should 'elements_sites' be around the same number of rows as 'elements'?
- Is it possible to somehow check what's still relative and in use and clear out the rest?
We've updated all plugins and Craft CMS to the very latest versions. We've had the Wishlist plugin installed from day 1 and when we experienced a slow CMS, we uninstalled then reinstalled and it worked much faster again (it creates a row/list for every user). Tried doing this recently but no joy. My hunch is that it has left loads of rows in there since updating over the years.
If anyone has any ideas, that would be awesome! (hope all this makes sense ;) )