not frontend , please contact support and send them the output of System / Settings / Error Log / Usage Diagnostics + Download All Log Files
this is a starting point on debugging what could be done on the backend (code) … we might need a Zoom call so bear that in mind. no need to explain the whole thing again, just reference this post (copy the url) on the ticket.
are you after a one report that shows all that? can probably be done with item reports … except when you mention “the criteria” bit, item reports must be “clicked” in order to obtain them…
nope , perhaps if you help us understand what is to be improved on that export other than the obvious slowness you have?
i know this wont sound very logic, but the slowness is not (or better: should not) be related to that volume, the problem is somewhere else and that somewhere else will be hopefully be fully improved on the new cake migration project: Feature - CakePHP upgrade (massive, complex and uncertain) … so while “deleting” things will do the trick for you is not a tool we want to use to deal with this type of problems.
updates on the database will be slower because each update does a full backup of the database, yours must be large and that is why you feel that slowness. the actual update process does not care how much data you have unless a data migration takes place on your large tables … but its very unlikely.
yes - makes sense mysql is the bottleneck because of the amount of short queries needed to build the pages you see in eramba when you click things on that section.