UBB.Developers Forums General Discussion Suggestions and Feedback Need comparisons - UBBThreads vs Vbulletin, etc...

Just to give some evidnce for my claims that queries are not the be all and end all, this is the result of my showthread.php on my site:

Page generated in 0.15240395069122 seconds with 23 queries,
spending 0.043401837348938 doing MySQL queries and 0.10900211334229 doing PHP things.

Page generated in 0.16944599151611 seconds with 23 queries,
spending 0.057216882705688 doing MySQL queries and 0.11222910881042 doing PHP things.

Page generated in 0.15401101112366 seconds with 23 queries,
spending 0.043453693389893 doing MySQL queries and 0.11055731773376 doing PHP things.

Page generated in 0.17569303512573 seconds with 23 queries,
spending 0.043526411056519 doing MySQL queries and 0.13216662406921 doing PHP things.

Page generated in 0.15374398231506 seconds with 23 queries,
spending 0.043373703956604 doing MySQL queries and 0.11037027835846 doing PHP things.

Just to give some evidnce for why the number of queries is not the most important thing, here the execution of the script takes generally double the time of that spent doing mySQL stuff.

Strangley enough, memberlist.php which has less queries takes longer:


Page generated in 0.36566996574402 seconds with 8 queries,
spending 0.27704405784607 doing MySQL queries and 0.088625907897949 doing PHP things.

Page generated in 0.24585998058319 seconds with 8 queries,
spending 0.13530337810516 doing MySQL queries and 0.11055660247803 doing PHP things.

Page generated in 0.26208698749542 seconds with 8 queries,
spending 0.15155696868896 doing MySQL queries and 0.11053001880646 doing PHP things.

Page generated in 0.30834305286407 seconds with 8 queries,
spending 0.23045933246613 doing MySQL queries and 0.077883720397949 doing PHP things.

Page generated in 0.34207499027252 seconds with 8 queries,
spending 0.28613305091858 doing MySQL queries and 0.055941939353943 doing PHP things.

This shows that:

a) Sometimes the PHP code takes longer to execute than the queries but you seem to ignore the time taken by PHP code in any evaluation of efficiency because you based it SOLELY on number of queries

b) That some scripts which have less queries take longer in mySQL than other scripts with more queries.

Pretty much defeats your argument.