With the devel module installed, I'm seeing database access times of between 600 and 1600 ms for the following query:
SELECT td.tid, td.name, n.nid, n.title, s.stype, s.sid FROM ((subscriptions s LEFT JOIN node n ON n.nid = s.sid) LEFT JOIN term_node tn ON tn.nid = s.sid) LEFT JOIN term_data td ON td.tid = tn.tid WHERE n.status = 1 AND s.uid = 1 AND s.stype = 'node'
Any suggestions on what I should be looking for to figure out why it's taking so long? Apologies in advance if it's something blindingly obvious.
This is on Drupal 4.6.3 with MySQL.
Thanks!
Adam Gaffin Executive Editor, NetworkWorld.com agaffin@nww.com / (508) 490-6433 / http://www.networkworld.com "I programmed my robotic dog to bite the guy who delivers the electronic mail." -- Kibo