A few weeks ago, I'd posted that doing an IP seach ("Search for more IPs for this user") effectively froze my server, due to there being over 1 million posts on my forum. Fair enough.
I was also told to create an index on the IP addy. But no one ever told me:
1) Exactly how to do that (table name, field name, and SQL syntax)
2) What were the ramifications vis-a-vis board performance
3) Would any CODE CHANGES be required in order to "activate" this new index
I would appreciate these issues being addressed.
Thanks
I was also told to create an index on the IP addy. But no one ever told me:
1) Exactly how to do that (table name, field name, and SQL syntax)
2) What were the ramifications vis-a-vis board performance
3) Would any CODE CHANGES be required in order to "activate" this new index
I would appreciate these issues being addressed.
Thanks
Comment