RSS Feed/News The xf_ip 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
23,679
Points
823

Reputation:

I've noticed that our xf_ip table has grown to 7.0GB in size. Doing a few queries, it seems our first entries go back to January 6, 2002, which is when the original vBulletin forum was started up. The table has 97,610,227 rows in it.

Aside from registration IP addresses, is there any reason we should be keeping history back this far? One use for IP address history is watching for banned members signing up again, as well as watching for spam activity. Beyond that, I'd think that...

Read more

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