Reply to thread

Message

<blockquote data-quote="Psionicist" data-source="post: 1839012" data-attributes="member: 1874">Hmm. That is not a good idea. In vBulletin you can set a debug parameter in the admin panel. Append &amp;explain=1 to the URL to see info about how long this particular page took to load.Here are some stas from forum.sweclockers.comforumdisplay.phpPage generated in 0.147233963013 seconds with 20 queries,spending 0.00681686401367 doing MySQL queries and 0.140417098999 doing PHP things.index.phpPage generated in 0.0895259380341 seconds with 19 queries,spending 0.0127546787262 doing MySQL queries and 0.0767712593079 doing PHP things.showthread.phpPage generated in 0.390783071518 seconds with 23 queries,spending 0.0175514221191 doing MySQL queries and 0.373231649399 doing PHP things.PHP is the bottleneck, not MySQL. And the current server is _slow_ IIRC it's a P4 Willamette (not even a northwood) with IDE-drives.My advice: Use only one server for now, a powerful one with dual CPUs. It will certainly handle up to 50000 forum members (my forum choked at 45000 members, but that was a dual 2.4 GHz Xeon which is slower than most operons).</blockquote>

[QUOTE="Psionicist, post: 1839012, member: 1874"] Hmm. That is not a good idea. In vBulletin you can set a debug parameter in the admin panel. Append &explain=1 to the URL to see info about how long this particular page took to load. Here are some stas from forum.sweclockers.com [b]forumdisplay.php[/b] Page generated in 0.147233963013 seconds with 20 queries, spending 0.00681686401367 doing MySQL queries and 0.140417098999 doing PHP things. [b]index.php[/b] Page generated in 0.0895259380341 seconds with 19 queries, spending 0.0127546787262 doing MySQL queries and 0.0767712593079 doing PHP things. [b]showthread.php[/b] Page generated in 0.390783071518 seconds with 23 queries, spending 0.0175514221191 doing MySQL queries and 0.373231649399 doing PHP things. PHP is the bottleneck, not MySQL. And the current server is _slow_ IIRC it's a P4 Willamette (not even a northwood) with IDE-drives. My advice: Use only one server for now, a powerful one with dual CPUs. It will certainly handle up to 50000 forum members (my forum choked at 45000 members, but that was a dual 2.4 GHz Xeon which is slower than most operons). [/QUOTE]

Verification