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

Re: SQL indices a WC format bump and 1.7

From: Philip Martin <philip.martin_at_wandisco.com>
Date: Fri, 02 Sep 2011 16:42:19 +0100

Hyrum K Wright <hyrum.wright_at_wandisco.com> writes:

> sqlite> select * from sqlite_master where type = 'index' and
> tbl_name = 'WCROOT';
> index|sqlite_autoindex_WCROOT_1|WCROOT|8|
> index|I_LOCAL_ABSPATH|WCROOT|9|CREATE UNIQUE INDEX I_LOCAL_ABSPATH
> ON WCROOT (local_abspath)
>
> would both indicate there are two indices on the WCROOT table, though
> we only define one. I believe one of these indices is due to the
> UNIQUEness of the local_abspath column.

Yes, that's why I think we can delete them. However we rarely write to
these tables so the overhead of having the superfluous index is
negligible. There is no real need to remove them from 1.7 if people
would prefer to make a more minimal change for 1.7.

-- 
uberSVN: Apache Subversion Made Easy
http://www.uberSVN.com
Received on 2011-09-02 17:42:54 CEST

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