Bug A table that could use some indexes

Status
Not open for further replies.

tavenger5

Customer
There is a table that could use some indexes: dbtech_thanks_recententry - on userid and receiveduserid

On members profiles that have a LOT of likes the select statements run on these columns was scanning through 10's of thousands of records. I know it's not a huge deal, but it could help with really active forums.
 
Last edited:
You can also reduce the number of days to keep data for via the vBulletin Options, that'll also increase performance :)
 
Status
Not open for further replies.

Legacy Advanced Post Thanks / Like

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
4,029
Customer rating
5.00 star(s) 1 ratings
Back
Top