[support] Really slow Views

[Anthony]

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 at 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/ ]
>



-- 

*Anthony Stefan Maciejowski*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20120710/17906833/attachment-0001.html