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

XF 1.4 Performance Optimization

Discussion in 'XenForo Questions and Support' started by Frank Cano, Jun 23, 2015.

  1. Frank Cano

    Frank Cano New Member


    We run a smallish forum but it has been around for a long time and thus, the SQL db is large and since we are small, we are on a budget host site. Looking to improve the SQL query speed. Any advice to get us pointed in the right direction would be greatly appreciated.

    Some questions along this line that we have already had:
    - does closing old threads improve query response time?
    - is there any optimizations we can do to the DB?
    - if we wanted to archive off all the old threads, how would we go about this?

  2. Brogan

    Brogan XenForo Moderator Staff Member


    Not really, although it's not clear what you mean by "optimizations".

    There is no archive function so nowhere to archive them to.
  3. thedude

    thedude Well-Known Member

    Have someone knowledgeable take a look at your MySQL (or MariaDB) .cnf file. Maybe it's optimized for MyISAM and not InnoDB. Maybe the buffer pool is too small. Maybe a lot of different things.

    To the db structure itself there's nothing really you can or should do like Brogan mentioned, but definitely try tuning the db engine.
  4. Frank Cano

    Frank Cano New Member

    Thank you all for the quick advice.

    Granted, but I could make two copies of the database and in one delete everything older than 2 years and in the other everything newer. Then for the older db, start up a second forum on a subdomain pointing to the old DB for those wishing to do searches for prior references.

    Poor man's archive function.

    Yea, we are on a budget hosting company that won't let us hack the SQL my.cnf file. Gonna likely change that.
  5. Brogan

    Brogan XenForo Moderator Staff Member

    That would require two licenses and it doesn't actually make any difference as far as performance is concerned.

    It's also not possible to selectively move content to another database, so how would you do that on a rolling basis?
  6. DurtySonuva

    DurtySonuva Member

    Would it make sense to split all of the old posts, put them into a separate 'archived' forum that isn't called on in the news or recent posts function?
  7. Frank Cano

    Frank Cano New Member

    That would be ideal if that functionality existed.

Share This Page