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

XF 1.2 Remove data from BB code cache (days)

Discussion in 'XenForo Questions and Support' started by MattW, Aug 28, 2013.

  1. MattW

    MattW Well-Known Member

    Just looking at some of the settings in the ACP, and wondering what other people have changed this setting to?

    Remove data from BB code cache (days)

    It's set to 30 by default, but is there any benefit to increasing it to store more cached BB codes?
  2. Brogan

    Brogan XenForo Moderator Staff Member

    I have disabled it completely.
    It massively increased the size of my database and overall it doesn't really offer much benefit.
  3. MattW

    MattW Well-Known Member

    Just had a look in the database, and that table is currently 103Mb. That does seem large, especially for a site with < 250,000 posts!
  4. LurkerLou

    LurkerLou Active Member

    What does this do exactly? And Brogan, how did you disable it completely?
  5. RoldanLT

    RoldanLT Well-Known Member

    Parsed BB code cache
    The parse tree of messages is now cached for a configurable length of time. Note that this is the parse tree, not the compiled output. The final compiled output is still handled at run time. This gives significant performance improvements, but does not limit the dynamic nature of BB code output (by style, language, or user viewing).

    This cache can easily be used by any content types.

  6. Brogan

    Brogan XenForo Moderator Staff Member

    Uncheck Cache BB Code output
    Lee Burnett likes this.
  7. Lee Burnett

    Lee Burnett Member

    After disabling it, can I safely run "DELETE FROM xf_bb_code_parse_cache;" to clear out all that data?

    Is there anything else I need to take into account?
  8. AndyB

    AndyB Well-Known Member

    You can safely empty (I use phpMyAdmin to Empty the table) the xf_bb_code_parse_cache at any time. No other tables need to be emptied.
    Lee Burnett likes this.
  9. AndyB

    AndyB Well-Known Member

    Thank you for this tip.
  10. Lee Burnett

    Lee Burnett Member

    Thanks - phpmyamdin uses truncate to empty the table. I'll use that command. :)

    TRUNCATE TABLE xf_bb_code_parse_cache;
  11. AndyB

    AndyB Well-Known Member

    Isn't there an Empty tab in phpMyAdmin? There is on my version. But yes phpMyAdmin uses the Truncate Query.
  12. Ben44

    Ben44 Member

    Where exactly is this setting?
  13. whynot

    whynot Well-Known Member

    Home > Options > Performance
  14. viper357

    viper357 Active Member

    Thanks for this, just emptied my xf_bb_code_parse_cache table, it was 433mb.
  15. Ben44

    Ben44 Member

    Thanks very much :)

Share This Page