[wp-hackers] Re: [wp-svn]  trunk/wp-includes: Add LIMIT
1 to some of our gets.
ryan at boren.nu
Tue Nov 8 00:12:53 GMT 2005
On Mon, 2005-11-07 at 23:18 +0000, Mike Little wrote:
> On 11/7/05, m at wordpress.org <m at wordpress.org> wrote:
> > Revision 3012 Author ryan Date 2005-11-07 23:09:09 +0000 (Mon, 07 Nov 2005)
> > Log Message Add LIMIT 1 to some of our gets.
> Is there some speed advantage to this?
> Each of the ID columns used to select is a primary key, there can only
> ever be one row returned by definition.
We had limit 1 on a couple of selects I replaced.
I remember these being added to fix a performance bug a couple folks
reported, so I just added the limits to our get methods. I don't know
if they make any difference.
More information about the wp-hackers