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.
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.
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?
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?
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.
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).
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 ;-)
Comments
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
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?