Re: [PERFORM] Adding "LIMIT 1" kills performance.

2008-05-29 Thread Chris Shoemaker
On Fri, May 30, 2008 at 02:23:46AM +0930, Shane Ambler wrote: > Chris Shoemaker wrote: >> [Attn list-queue maintainers: Please drop the earlier version >> of this email that I accidentally sent from an unsubscribed address. ] >> >> Hi, >> I'm having a stra

[PERFORM] Adding "LIMIT 1" kills performance.

2008-05-29 Thread Chris Shoemaker
[Attn list-queue maintainers: Please drop the earlier version of this email that I accidentally sent from an unsubscribed address. ] Hi, I'm having a strange problem with a slow-running select query. The query I use in production ends in "LIMIT 1", and it runs very slowly. But when I remove the