[support] Really slow Views

[Ms. Nancy Wichmann]

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.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20120710/dcc4f235/attachment.html