While validating some code, I accidentally called a wrong function within a loop, and the result is what I believe is a XenForo record, and it is with great honor that I am the one to hold it.
Actually, the time is twice what I am used to, so it's pretty high for me. For the test, I expected 60 additional queries (12 for each time through the loop).
The add-on is to allow Admins to control banner ads. It normally averages just two additional queries, which is pretty good considering there are 5 Ad spots which can contain a different banner each.
Because what happens in between the loops is what matters . This loop is one that went awry and crazy yet still managed to achieve a very decent speed/time/query ratio.
The vBulletin 4 loop is supposed to be optimized and production quality, but speed/time/query ratio is still enormous.