Vanilla 0.9.3 Scalability

Mark

*tips hat @ kosmo*

MrNase

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

Jazzman

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 ^^

jos

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.

Jazzman

1080647 posts.... :O

jos

I found it on http://www.big-boards.com/ There is other board software mentioned too.

Mark

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.

Bergamot

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?

jos

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?

Bergamot

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.

Mark

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

Bergamot

Sweetness

Seth

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 :)

Bergamot

Sadly, some of us are still forced to use PHP4 by other things (Wordpress, for one)

jos

WP is now in 2.0rc1 so that might solve php5 problems.

MrNase

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 ;-)

Bergamot

I disagree

Jazzman

disagree on what?

Mark

http://lussumo.com/community/comments.php?DiscussionID=713&page=1#Item_39

enderateros

today is the *last* day of november!