search

thomasgriffin / theme

Theme for Pippinsplugins.com
2 stars 3 forks source link

Slow site #57

Open amdrew opened 9 years ago

amdrew commented 9 years ago

For some reason there are a number of slow queries. Adding items to cart is painfully slow. I'm not entirely sure but from what the query monitor plugin is reporting they seem to be coming from EDD.

pippinsplugins commented 9 years ago

Looks like it may be coming from this query:

SELECT pp_users.ID,pp_users.user_login,pp_users.display_name
FROM pp_users
INNER JOIN pp_usermeta
ON (pp_users.ID = pp_usermeta.user_id)
WHERE 1=1
AND ( (pp_usermeta.meta_key = 'pp_user_level'
AND CAST(pp_usermeta.meta_value AS CHAR) != '0') )
ORDER BY display_name ASC

Not yet sure what's firing that.