Nancy how were the queries created. Manually or automatically by views?
On Tue, Jul 10, 2012 at 10:15 AM, Ms. Nancy Wichmann <nan_wich@bellsouth.net
wrote:
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 Holly What 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/ ]