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

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