Unexpectedly Setting a new XenForo Record
- Thread starter Lawrence
- Start date
ManagerJosh
Well-known member
Don't just look at the queries. Look at the times!While validating some code, I accidentally called a wrong function within a loop, and the result is what I believe is a XenForo record.
View attachment 5763
hint: look at the queries.
I bet with that annoying loop, xenForo would still beat vBulletin 4 
FreshFroot
Well-known member
haha wow! How did your database not overload.. melt.. and send off the local fire alarm
FreshFroot
Well-known member
I never looked at the time! Wahoo!!! Two records!
The time actually is impressive.....
BTW what mod are you working on Lawrence? or were u just fooling around with stuff?
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.
Paul M
Well-known member
How would a small php loop be any different in either ?Don't just look at the queries. Look at the times!
Ryan Ashbrook
Active member
I managed to get almost 500 per page load in threads on vB2 once. That was funny.
Not gonna lie either, for 165 queries the timing is kind of impressive.
Not gonna lie either, for 165 queries the timing is kind of impressive.
ManagerJosh
Well-known member
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.
Similar threads
