Tips that can reduce the load on your MySQL Server:
  • Use partial new post tracking instead of full new post tracking in your config file.
  • Set the theme file to show a smaller number of topics per page on the postlist screen and smaller number of posts to be shown in flat mode (recommend 10 each). This will reduce the load that anonymous users have on the forum.
  • If your theme file was set to a large number of posts per page - you can update all existing members to a lower amount with this query:
    (Backup your database first)
    UPDATE w3t_Users
    SET U_PostsPer = 10,
    U_FlatPosts = 10

    Users can still select a higher amount in their display prefs, but for the masses this can reduce the overall load.
  • adjust the settings of each forum to show a reduced range of topics. Example if they are all set to show "all topics" - set each forum to show only topics from the last 30 days etc...

Joshua Pettit
Web Developer
www.ThreadsDev.net | www.JoshuaPettit.com