Thanks, Jamie and Earnie. I finally found the code in a block. The queries had an incredibly bad sub-query for an IN clause. But it turns out that the block was a first attempt to get the data that the Views were generating, so the block wasn't even needed anymore. Removing that block brought the page down to 1.5 seconds. 10 hours to find, 10 seconds to fix...
Nancy
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
From: Jamie HollyWhat Earnie said. Whenever you do sites with views, it's always best to
spend some time and put the queries into mysql and do an explain. Even
if you see queries executing in decent times, it's still best to double
check because it could still be doing a full scan, but you just don't
have that much data in at development.
A lot of times you can fix them with indexing, but there are the
occasions when you actually need to rewrite the query in a module.
--
[ Drupal support list | http://lists.drupal.org/ ]
Anthony Stefan Maciejowski