Optimization for "Last Post in Profile"
Mod Version: 1.0.1, by Andreas
This modification is in the archives.
| vB Version: 3.5.0 RC3 | Rating:  (0 vote - 0 average) |
Installs: 11 |
| Released: 27 Sep 2005 | Last Update: 28 Sep 2005 | Downloads: 18 |
 Not Supported
 DB Changes
Uses Plugins
Is in Beta Stage
|
||
Optimization for "Last Post in Profile"
Description
vBulletin has a feature to display information about the last post made by a user in his profile.
However, this can be very server intensive:
But: How often does it happen that the last post is NOT accessible?
If your answer is seldom, then this Hack is for you:
It directly fetches the last post info in this case, without the need for any table scans.
Drawback: If the last post is NOT accessible, then it causes one additional, pretty light query and some PHP processing in member.php.
More background Info: http://www.vbulletin.com/forum/bugs35.php?do=view&bugid=1405
ATTENTION: Due to Multi-Table UPDATEs being used in the installation code of this product, you will need at least mySQL 4.0.4 in order to install this properly.
If you install it with an older Version, it will still work - however it will always cause the additional query then for all users until they have made a new post.
History
1.0.0
Initial Version
1.0.1
Minor http://www.vbulletin.com/forum/bugs35.php?do=view&bugid=1408
Description
vBulletin has a feature to display information about the last post made by a user in his profile.
However, this can be very server intensive:
Quote by vBulletin Admin Control Panel
These table scans are necessary because vBulletin does not know if the last post is accessible (eg. not soft-deleted, not in moderation and not in a forum where the viewing user does not have access rights).Show Last Post on Profile Page
Showing the last post on a member profile can cause large table scans which leads to table locking.
This may increase load time on your forums as well as the load of your server.
This option should only be enabled for smaller forums.
But: How often does it happen that the last post is NOT accessible?
If your answer is seldom, then this Hack is for you:
It directly fetches the last post info in this case, without the need for any table scans.
Drawback: If the last post is NOT accessible, then it causes one additional, pretty light query and some PHP processing in member.php.
More background Info: http://www.vbulletin.com/forum/bugs35.php?do=view&bugid=1405
ATTENTION: Due to Multi-Table UPDATEs being used in the installation code of this product, you will need at least mySQL 4.0.4 in order to install this properly.
If you install it with an older Version, it will still work - however it will always cause the additional query then for all users until they have made a new post.
History
1.0.0
Initial Version
1.0.1
Minor http://www.vbulletin.com/forum/bugs35.php?do=view&bugid=1408
Download
This modification is archived and cannot be downloaded.