We would like to point out this has a serious problem on the profile page. Where you set your hook in the profile page for stats for the profile in member_profileblock_fetch_unwrapped you didnt specify a block id so the query is basically run inside a loop so you get one call of the query per block instead of just calling it once.
We had 16 queries on our profile page from that hook so for now since we were wanting to show the awards stat somewhere else I just adapted the code and moved it to another hook for now instead of setting up an id like should have been done. Basically if you have 16 blocks on your profile page thats 16 queries instead of 1 without the id.
Later we will see about posting up some fixed code when we go and add it back into the statistics tab on our site. But this is just a heads up for the developer and any big sites using this modification right now who may want to disable that hook location for the moment if they are having high loads since installing this modification.
|