SMF in a multi-forum environment

[webworldx]

SMF Version: SMF 1.0.7
This might be outside the context of this forum, but thought i'd try anyway!  How does SMF perform if you've got, say, 100+ installations per server?  I'm looking at the possibility of modifying it to increase speed in this situation - possibly one set of board files and a large DB?

Thanks for any info!

[Ben_S]

Would depend on how you did it, if you had one huge table for messages then you would have problems with search etc but if you have seperate tables for each board, then it shouldn't really perform much different to totally individual instalations.

[webworldx]

Thanks for the reply Ben, it would be different tables rather than just one.   I'm just thinking on whether 100 tables in one database, and constant connections to this database would hinder performance in any way.  There could be 50 members online on each of the forums at any one time, so that's 5,000 connections to one database.  But if there's little performance difference, then that's great

I'm almost certain the answer to this will be "most definately", but i'm guessing the SMF performance is much better than the original YaBB pre 2?

[webworldx]

-bump-

[Ben_S]

It should outperform YaBB 2 by quite a margin. The YaBB team have done great with YaBB 2 but flatfiles are inefficient in reallity.

[webworldx]

That's great, thanks a lot I know the YaBB team have done great with v2, it was pre v2 I was talking about, so if it outperforms the current version in this setup - brilliant