Quote:
Originally Posted by chip
|
Ok, confirmed. I suspect the problem being that we have now over 77million rows in the database that contains uploads/downloads, meaning a total of 77million files have been transferred since 2018.
The database have simply become to large for a query of this type, even with indexes. It works, but it takes so long to get the information that the website times out when waiting for it.
I'll come up with a solution. I think I have to split up the table into separate ones.
If we have a MariaDB expert in the ranks here, I'd love to hear from you =)