According to showthread.php you are correct in saying that vBulletin doesn't do a query for every post. However, the function $postbit_factory->fetch_type($fetchtype) apparently calls a query. Where? I'm not sure. And why do certain users experience this madness and others don't? That I also don't know. All I know is that by controlling the number of times fetch_type() is called, those of us with query issues on showthread (20 - 25 queries) can now relax with 12 - 15 queries.

oh man it's just too bad it doesn't work for me.

PHP & MySQL versions? PHP cache? Dedicated server?

Oh wow! Damn! I mean WOW! I saved over 200 memory! The forum speed is now 10x times faster! I mean wow... this has to be the greatest tweaking I've ever saw! I hope Jelsoft includes this!

As far as I can tell, the only way this hack will reduce the number of queries is if you have hacks that use the postbit hooks. If you do have hacks that use those hooks, then this hack may do more harm than good as it will bypass the calls to those hooks.

Uninstalling... This didn't make any change for me.

To argue with all those who say there are no queries in the postbits, there are actually a number of queries vBulletin can possibly make during each cycle. I have been investigating this extensively, following function call to function call.

In class_postbit.php, the function call to cache_permissions() - cache_permissions is defined in functions.php and can execute a query under certain conditions. Tested, and this is not our extra query.

In class_bbcode.php, queries can be made to the table bbcode and smilie if $vbulletin->bbcodecache or $vbulletin->smiliecache are empty. Tested, and this is not our extra query.

I will be adding to this over time as I investigate further.

EDIT: I found the cause of the queries.

A little product called: Username Management
Has a plugin included for: postbit_factory
Plugin is called: Add Username history to postbit(legacy)

I don't know why the coder used a separate query for this when only a $hook_query_fields addition was necessary.

Is there a reason why this is no longer up for download?

coz not necesairy. I installed it but I had before and after same queries and same page generating time.. not useless for me.

I'm sure on smaller boards it is pretty useless but I have a semi-large site so I wanted to test it out.