The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
Error in database caused by product
I was recently suspended by my web host as one of my plugins was causing an overloading mySQL, due to the following part:
HTML Code:
mysql> use DATABASENAME Database changed mysql> explain SELECT DISTINCT `live_dbtech_thanks_entry`.*, `live_user`.`username`, `live_user`.`displaygroupid` FROM `live_dbtech_thanks_entry` JOIN `live_user` ON (`live_user`.`userid` = `live_dbtech_thanks_entry`.`userid`) WHERE `contentid` = '2132714' ; +----+-------------+--------------------------+--------+----------------+---------+---------+----------------------------------------------+--------+------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+--------------------------+--------+----------------+---------+---------+----------------------------------------------+--------+------------------------------+ | 1 | SIMPLE | live_dbtech_thanks_entry | ALL | entryid,userid | NULL | NULL | NULL | 726933 | Using where; Using temporary | | 1 | SIMPLE | live_user | eq_ref | PRIMARY | PRIMARY | 4 | wukohi_forum.live_dbtech_thanks_entry.userid | 1 | | +----+-------------+--------------------------+--------+----------------+---------+---------+----------------------------------------------+--------+------------------------------+ 2 rows in set (0.00 sec) |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|