On Thu, Jun 2, 2011 at 12:32, <[email protected]> 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
