kilotango said:
@Subloaded, try running mysqltuner. it can point out issues quite easily with regards to the db setup
It's quite hard when we don't actually have the db, locally, at our perusal. I wish I had a backup that I could restore but it is just too large to download.
The DB and the site sit together on the same server as one project/solution as well which isn't nice for this scenario.
I will look into this as well as I've never needed to, or have used, mysqltuner.
General work with Ms sql server and noSQL DBs but I will read into this. Thanks!