The Big Forum List

[grantus]

If you can add my forums, that would be great, thanks!

Over 250,000 posts: http://www.illmuzik.com/forums/

 

[ibnesayeed]

Urdu Mehfil @ http://www.urduweb.org/mehfil/ has crossed the 1,000,000 posts milestone last month.

 

[Steve10]

Updated! If anyone spots any mistakes or has any further sites to add feel free to post about it.

 

[BigPete7978]

Well considering my site ThatGamerForum is still growing I know I will be posting here as soon as it reaches the 100k mark

 

[Digital Doctor]

FYI for the big forum people !

The query that runs to find how many threads are in a forum (every time you view a forum) is something like this...

SELECT COUNT(*)
FROM xf_thread AS thread
WHERE (thread.node_id = 27) AND (thread.sticky = 0) AND (thread.discussion_state IN ('visible','deleted','moderated'))

There is not an index that can be fully utilized since no index has discussion_state in it. If your forum has a lot of threads in it and can cause noticeable speed issued with a high number of threads in a forum (more than a second to run the query).

While I've already done it on my setup, I'd suggest an index with the 3 fields: node_id, sticky, discussion_state be added to the xf_thread table for scalability reasons for others.

 

[uniK]

http://fr.decerto.net

Forum Statistics
Discussions: 11,303
Messages: 194,834
Members: 13,930

 

[Volion]

Updated! If anyone spots any mistakes or has any further sites to add feel free to post about it.

100k+ link in signature. "new installation, March 24, 2012"

 

[ashkir]

RPG-Directory.com has hit 500,000 officially once agian.

(We deleted several hundred thousand)

 

[Werldklass]

Wow, this is my dream

 

[GoodForAnother]

http://the-mainboard.com

Discussions: 116,806
Messages: 8,207,291
Members: 14,052
We imported from SMF back in August 2011.

 

[CivilWarTalk]

http://civilwartalk.com/

500,000 + messages, we converted from vB4 almost exactly a year ago!

 

[Steve10]

Updated The list is correct and up to date (to the best of my knowledge) as usual if you spot any mistakes just mention and if there are any sites missing then I'm happy to add them.

Edit: There's now also an extra category of differentiation which is ranked at the 2.5 million posts mark as the more than 1 million list was getting quite long. Its also worth noting that as the list increases in size I may reassess minimum criteria but that shouldn't be for a while.

 

[Volion]

Updated The list is correct and up to date (to the best of my knowledge) as usual if you spot any mistakes just mention and if there are any sites missing then I'm happy to add them.

Edit: There's now also an extra category of differentiation which is ranked at the 2.5 million posts mark as the more than 1 million list was getting quite long. Its also worth noting that as the list increases in size I may reassess minimum criteria but that shouldn't be for a while.

Are you still highlighting new installations, not imports in orange?

 

[Steve10]

Are you still highlighting new installations, not imports in orange?

Yeah, they are/should be.

 

[dvduval]

You can add dance-forums.com with just short of 1,000,000 posts and salsaforums.com with just over 200,000 posts.

 

[Shane Greer]

http://www.thefewgoodmen.com/thefgmforum/

It was a port from vB4 but has exploded since going to Xenforo.

 

[Alex12]

http://www.ge-ru.com/forum/
Over 100K post. It's mine.

 

[AWS]

Just converted http://computerhelpforums.net to xenforo.

150K+ posts.

 

[rdn]

100K Plus: http://www.phcorner.net/
38K Members

 

[mcadx]

MotorcycleAddicts.org - over 350,000