[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: svn commit: r1081484 - in /subversion/trunk/subversion/libsvn_wc: wc-queries.sql wc_db.c

From: Stefan Sperling <stsp_at_elego.de>
Date: Mon, 28 Mar 2011 13:32:46 +0200

On Sat, Mar 26, 2011 at 09:46:48AM -0400, Greg Stein wrote:
> If it only needs to detect a single row, then LIMIT 1 should be in the
> query.

Is there really a significant difference between LIMIT 1 and not stepping
through more than one result row?

I'd rather keep the queries reusable for contexts where a complete
list of modified nodes is required, instead of adding COUNT() (as
suggested elsewhere) or LIMIT 1.
Received on 2011-03-28 13:33:23 CEST

This is an archived mail posted to the Subversion Dev mailing list.