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

Re: Really lousy performance with svn info --depth infinity

From: Philip Martin <philip.martin_at_wandisco.com>
Date: Thu, 01 Sep 2011 17:36:04 +0100

Philip Martin <philip.martin_at_wandisco.com> writes:

> At first glance the difference between recursive and non-recursive is
> node.c:walker_helper. Is STMT_SELECT_NODE_CHILDREN_WALKER_INFO missing
> an index?

Look at the comment:

-- STMT_SELECT_NODE_CHILDREN_WALKER_INFO
/* ### See comment at STMT_SELECT_NODE_CHILDREN_INFO.
   ### Should C code handle GROUP BY local_relpath ORDER BY op_depths DESC? */
SELECT local_relpath, op_depth, presence, kind
FROM nodes
WHERE wc_id = ?1 AND parent_relpath = ?2
GROUP BY local_relpath
ORDER BY op_depth DESC

Perhaps GROUP BY and ORDER BY are the problem. Perhaps they defeat the
index? Perhaps we need to do it like STMT_SELECT_NODE_CHILDREN_INFO, in
C.

-- 
uberSVN: Apache Subversion Made Easy
http://www.uberSVN.com
Received on 2011-09-01 18:36:38 CEST

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