I've inherited a Drupal site that is experiencing slow load times and I'm trying to troubleshoot the problem. The site is run on a dedicated box with what should be enough resources.
I ran the Devel module to see the MySQL queries and it's telling me that the following query is being run four times taking a total of 2-3 seconds.
execute SELECT DISTINCT node.nid AS nid, node.title AS node_title, node_revisions.body AS node_revisions_body, node_revisions.format AS node_revisions_format, node.sticky AS node_sticky, node.type AS node_type FROM node node LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid WHERE node.status = 1 ORDER BY node_sticky DESC
There are almost 400 other queries that are taking over 10 ms, but this one above is by far the longest and that it is being run multiple times, I suspect is causing some of the load problems.
Any suggestions on what is going on here or where to look for more information? All modules and core files are up to date.