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.
Options

Vanilla 0.9.3 Scalability

2

Comments

  • Options
    MarkMark Vanilla Staff
    *tips hat @ kosmo*
  • Options
    edited November 2005
    Can't wait for 0.9.3 - the changes sound nice! :)


    Well, I wouldn't say that. punBB averages out on my server at 0.035 seconds, and ThWBoard not far behind.

    ^ I take this one as a compliment being one of the former ThWboard Developers :D
  • Options
    edited November 2005
    I said I'd try to get it out before the end of November, and that's still my plan.
    Woohooo.... almost end of November ^^
  • Options
    How does Vanilla's speed compare to punbb? Is it that much slower? Would it crash if it would have to handle something like http://www.macaddict.com/forums/ ? How would it compare to phpbb? That board isn't known for its speed and is known to handle very large sites.
  • Options
    1080647 posts.... :O
  • Options
    I found it on http://www.big-boards.com/ There is other board software mentioned too.
  • Options
    MarkMark Vanilla Staff
    I haven't had a chance to test it with that kind of size. If someone wanted to do a port and run some tests, I'd be happy to oblige. The new version will scale better than the current version. I've been doing some optimizations over the last few days, and it's slow going finding bottlenecks. If you're looking for a flat-out fast forum, punbb is certainly a good answer.
  • Options
    The rendering code won't take any longer to execute for an enormous forum than a medium sized forum, since it's only displaying a max of 50 posts at a time, not 1080647. As far as database code goes, are there now indicies on important columns like LUM_Discussion.DateLastActive?
  • Options
    josjos
    edited November 2005
    The rendering code won't take any longer to execute for an enormous forum than a medium sized forum, since it's only displaying a max of 50 posts at a time, not 1080647.

    But doesn't that imply that it won't make any difference whether there are 50000000 posts or 50? Or is it just the number of simultaneous users that count?
  • Options
    Well the database still takes longer to look through 5000000 posts than it does for 50, and it takes longer to look through an unsorted table than a presorted table.
  • Options
    MarkMark Vanilla Staff
    edited November 2005
    Yes, there are a bunch of indexes on the database now, including LUM_Discussion.DateLastActive. But more importantly, I have gone through and: 1. Removed unnecessary columns from the queries 2. Isolated expensive mysql function calls and replaced them with faster methods 3. Tested Vigorously The comment search, for example, has gone from taking 50 seconds on a db with appx 430,000 comments to 0.4 seconds on the same data. I managed to get the discussion index query to scale very well (as mentioned in another thread a few weeks ago), and more recently I've been able to speed up the page further by making some php optimizations, reducing the rendering time by 50% (now down to appx 0.3 seconds for the page to render completely on a db with appx 30,000 discussions).
  • Options
    Sweetness
  • Options
    PHP 5.1 will obviate the speed differences for OOP / non-OOP, so we'll be seeing even greater speed increases once it goes mainstream :)
  • Options
    Sadly, some of us are still forced to use PHP4 by other things (Wordpress, for one)
  • Options
    WP is now in 2.0rc1 so that might solve php5 problems.
  • Options
    mark: This all sounds great but I think you should stop talking about 0.9.3 unless you have the files already uploaded to the server and ready for download ;-)
  • Options
    I disagree
  • Options
    disagree on what?
  • Options
    MarkMark Vanilla Staff
    http://lussumo.com/community/comments.php?DiscussionID=713&page=1#Item_39
  • Options
    today is the *last* day of november!
This discussion has been closed.