Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Scaling, load balancing



  • Must have been a helluva lot of robot activity! Glad you got it sorted though...
  • edited December 2010
    At rellsh's problem above (, I wondered if it is a similiar problem which I read in the FluxBB forum (

    According to the thread, a large topic with many posts would be slow to display the last page. Upon further inspection they found that such slow queries often join many tables and use the LIMIT clause in a single query, just like the query rellsh posted two years ago. They tried several alternatives before settling for rewriting the slow query into two smaller one, one that gets post IDs and one that joins those post IDs.

    A user reported that on a topic with 17K posts, the two-query approach reduced total time from about 0.5-0.6s to 0.02-0.03s (

    Just thought their approach might also help solve rellsh's problem. Have Vanilla 2 already adopted similiar solutions on that kind of database queries?
Sign In or Register to comment.