1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Performance compared to vBulletin?

Discussion in 'XenForo Pre-Sales Questions' started by Philip Morton, Oct 1, 2010.

  1. Philip Morton

    Philip Morton Member


    My biggest problem with vBulletin (3.8) is its performance. When you have a lot of posts, especially topics with thousands of replies, MySQL queries can take over a minute and crash the server. Recently I've had to actively seek out longer topics (2k+ replies) and stop them before they cause downtime.

    What performance improvements will XenForo have over vBulletin? Is it better optimised for larger forums or are huge topics an inherent problem?


  2. Kier

    Kier XenForo Developer Staff Member

    The number of posts in a thread has a negligible effect upon XenForo's performance.
    CurveGotti and Philip Morton like this.
  3. Kier

    Kier XenForo Developer Staff Member

  4. Philip Morton

    Philip Morton Member

  5. Neutral Singh

    Neutral Singh Well-Known Member

    i think it is the amount of content of the posts which makes the loading of a particular page slow. It has nothing to do with number of posts in a thread! Thread quoted above has all he posts with only two three words in them.... it would be interesting to see how XF behaves when there a lot of bulky posts in a thread.

    Just created this thread to test!

  6. Jarod

    Jarod Active Member


    personnaly i don't have problems with large posts with vbulletin. I have post with thousands of replies.
  7. Philip Morton

    Philip Morton Member

    The problems I've been seeing have been queries that vBulletin does when, say, it's counting the number of posts in a topic. For example:

    SELECT COUNT(*) AS posts​
    FROM post AS post​
    WHERE threadid = 5348 AND visible = 1​
    AND dateline <= 1228073906;​

    These kind of queries can take over a minute, at which point my host has been killing them, which also briefly takes the server down with it.

    Once I had figured this out, I got rid of any topic above 2,000 posts in length. This solved the issue immediately. However, keeping track of long topics is a pain!
  8. mlx

    mlx Well-Known Member

    For vBulletin 3 try adding this additional index. I think it really helped on our forum.

    ALTER TABLE post ADD KEY `th_search` (`threadid`, `visible`, `dateline`);
  9. Walter

    Walter Well-Known Member

    The field "visible" isn't a good index member, at least do it the other way: threadid, dateline, visible.
    Vladislav Rastrusny likes this.

Share This Page