Philip Martin <philip.mar...@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
