Announcement

Collapse
No announcement yet.

IP Search freezes server

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Dennis Olson
    replied
    Haven't done it yet. My board is VERY busy, and I'm also mirrioring to another server. I need to run down an issue or two before I perform the SQL. I'm going to ask about the dropping of the board on a separate thread, in hops someone from vB can answer that issue specifically. I'll let you know how it works out...

    Thanks for the info BTW!

    Leave a comment:


  • Lats
    replied
    How good was my guess on this Dennis?

    Leave a comment:


  • Lats
    replied
    Umm, good question.

    At a guess, it should only take around 5 - 10 seconds to perform that action on the number of posts you have, but to be on the safe side, close it down.

    Leave a comment:


  • Dennis Olson
    replied
    Thanks Lats! One more question - do I have to shut the board down for this, or can I do it "live"? (I assume I have to shut down).

    Leave a comment:


  • Lats
    replied
    1. ALTER TABLE user ADD INDEX (ipaddress)

    2. Increase in performance when search on IP address.

    3. None required, the database will use the index automatically.

    Leave a comment:


  • Dennis Olson
    started a topic IP Search freezes server

    IP Search freezes server

    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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X