PDA

View Full Version : Query in my slow query log


mindhunter77
08-05-2009, 10:08 PM
Is there a way to optimize this at all? This one keeps showing up in my slow query log over and over again.

# Query_time: 5 Lock_time: 0 Rows_sent: 25 Rows_examined: 43681
SELECT *,
IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid
FROM vbuser WHERE usergroupid = '2' ORDER BY RAND() LIMIT 25;

Marco van Herwaarden
08-06-2009, 07:15 AM
That doesn't seem to be a default vB query. I suggest you contact the author of the modification that uses this query.

mindhunter77
08-06-2009, 09:17 PM
any idea how to track down what mod may be using it ?

Lynne
08-06-2009, 09:38 PM
Do a search through your plugins (there is a mod that allows you to do this).

mindhunter77
08-06-2009, 10:47 PM
I ok, I looked through the search and came up with no mods, do you remember the name, or maybe a search word I could use to try and find it lol..

Lynne
08-06-2009, 10:53 PM
<a href="https://vborg.vbsupport.ru/showthread.php?t=203933" target="_blank">Search the plugincode</a>

mindhunter77
08-06-2009, 11:00 PM
Thanks Lynne!