RSS Feed/News Very large xf_rm_resource_download table

Status
Not open for further replies.

ENXF NET

Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
Joined
Nov 13, 2018
Messages
26,091
Points
823

Reputation:

Our site has lots of downloads, of lots of resource versions, by lots of users...
As a result xf_rm_resource_download (plus its index) is many GB in size and still growing.
Are there any mitigations for this?

My understanding is that I can't just prune the file, because of how other things fit together (e.g. resource ratings), but hopefully I've misunderstood.

Continue reading...
 
Status
Not open for further replies.
Top