Please read the original post by the author of this hack.
It will explain why it was taken out...

Yes, but to clarify: some users have reported that they did not have that product (Username Management) installed and still had high query counts.

There are a number of plugins that cause this, although in one case I have been unable to determine the origin of the 1 query per post.

If you have ibProArcade installed, there is a plugin which allows you to show crowns, etc. in the Postbit. This could potentially add 2 queries per post, so disable it.

If anyone has ibProArcade installed and can tell me the name of the plugin, I will include it in the first post.

Also, if you had neither of these installed and your query count on showthread is unusually high (around 20), post here, and we can work together to identify all the bad plugins (and request that the coders use $hook_query_joins in hook showthread_query instead).

I will re-upload the file for members to download as a troubleshooter in this respect, not as a hack.

I am looking to try this. How can we check how many Query it is using?

Enable Debug mode.

Installed and it looks like its working from 20 queries down to 14 !!!
I will keep and eye on it for awhile to make certain this is for real :)

You might want to read this earlier post again. You might be breaking any plugins you have installed that use the pobit hooks.

In case you haven't read the description to this hack recently, or my extensive post on the purpose of the hack: the point IS to break those plugins. The fact that your queries dropped means that you have plugins installed that aren't properly optimized and should either be rewritten (if you have experience coding) or disabled.

No negative side effects to date. I have been working on the forum since yesterday testing things out.

Thanks for a great hack!

11 - 0 = 11 ... So no change for me. This is on a thread viewing 40 posts.

I appreciate your efforts and I'm glad it seems to help out those with more queries. I just wanted to post that it didn't affect mine. Thanks!

10 queries is the lowest I've been able to get queries on a showthread page. This is with NO attachments and NO polls. An attachment(s) will add 1 query to the entire thread, and a poll will add 2.

So if you have 10-13 queries, as a rule you probably don't need any optimization.

For me, so far I've been able to join all queries that do anything on a showthread page except the 2 additional poll queries. They seem to be a little more complicated.