Gary Stainburn writes:
> I've posted th explain analyze at
> http://www1.ringways.co.uk/explain_analyse.txt
> I've marked a line with a sort in that appears to be the bit that's taking
> the
> time. Am I right?
Well, it's not really that big a part of the whole cost: only 150ms
out of the tot
On Tuesday 21 September 2010 15:20:15 Gary Stainburn wrote:
>
> I've posted th explain analyze at
>
> http://www1.ringways.co.uk/explain_analyse.txt
>
> I've marked a line with a sort in that appears to be the bit that's taking
> the time. Am I right?
>
I've had a look at this, and I can't even s
On Tuesday 21 September 2010 15:11:09 Craig Ringer wrote:
> On 09/21/2010 08:25 PM, Gary Stainburn wrote:
> > Hi folks,I have a view that seems to be very slow compared to similar
> > views on the same server.
> >
> > I've had a look at running explain but I don't really understand it.
> >
> > I've
On 09/21/2010 08:25 PM, Gary Stainburn wrote:
Hi folks,I have a view that seems to be very slow compared to similar views on
the same server.
I've had a look at running explain but I don't really understand it.
I've posted the view and the output from explain at
http://www1.ringways.co.uk/expl
Hi folks,I have a view that seems to be very slow compared to similar views on
the same server.
I've had a look at running explain but I don't really understand it.
I've posted the view and the output from explain at
http://www1.ringways.co.uk/explain.txt
This is an old view on a database that
