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

On Thu, Jun 2, 2011 at 12:32, <philip_at_apache.org> wrote:
>...
> +++ subversion/trunk/subversion/libsvn_wc/wc-queries.sql Thu Jun  2 16:32:18 2011
> @@ -726,6 +726,10 @@ VALUES (?1, ?2, ?3)
>  SELECT locked_levels FROM wc_lock
>  WHERE wc_id = ?1 AND local_dir_relpath = ?2
>
> +-- STMT_COUNT_WC_LOCK
> +SELECT COUNT(*) FROM wc_lock
> +WHERE wc_id = ?1

You don't need the actual count. Just whether one exists. Thus, I'd
recommend switching this over to STMT_HAS_WC_LOCK and do a simple
select with LIMIT 1 on it. Basically: it will be much easier on SQLite
because it doesn't have to count the number of rows. Just give you
one.

>...

Cheers,
-g
Received on 2011-06-02 18:50:38 CEST