Re: Re: DB getRow() and limit 1

Lukas Smith wrote:

Justin Patrin wrote:

On Wed, 24 Nov 2004 22:59:29 +0100, Lukas Smith <lsmith@php.net> wrote:

Brice Joly wrote:

Hi, I'm wondering whether getRow() includes an auto-appended "limit 1" or if it has to be manually added into the SQL query to avoid searching through the whole table once the expected record has been found. Same question for getOne().

no it does not.

Because some DB backends don't support it or have different syntax for it? Could the backends which support it implement a wrapper which adds it?

there is emulation in place for all relevant drivers to handle limit. however in some cases its rather nasty, so the best way is just to write proper queries.

note however that I have added it to MDB2 a while back if i remember correctly. The two main reasons why I have it there is that in MDB2 its easier to combine limits with any query that executes a query and also I have stayed away from overly complex limit emulations (which means that for those RDBMS they get a more severe performance hit when people rely on limit). regards, Lukas