Re: BoardIndex query
Reply #9 –
So sounds like we can safely add the ORDER BY with no penalty, and in fact its needed for some DB setups.
Looking at things I did that no cache but only on one of the querys, so I should rerun it, but then again the results say the same thing anyway!
Re: BoardIndex query
Reply #10 –
I updated the gist in a less lame way, to grab the moderators only in a single query at the end of the loop.
Unless I did something wrong, that way of doing looks quite faster (about 30%) than the single query with joins.
I also tried to cache the results of the moderators, though there is not a lot of difference, mainly because if there is the cache an additional loop is needed (see the two files in the gist): one to get the moderators and cache them, one to read the array cached and put the moderators into the boards/categories array.