Philip Martin <philip.mar...@wandisco.com> writes: > The query STMT_SELECT_NODE_CHILDREN_WALKER_INFO as used in 1.7 > > 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 > > performs poorly and doesn't scale well with working copy size.
After some more discussion in IRC it seems that the above SQL is dubious: the selected columns may not all come from the same row, and we may not get the highest op_depth. Using NODES_CURRENT would fix the problem as does my C solution, and the combination of the two is now on trunk. So I'll be proposing r1164426 and r1164614 to fix the 1.7 performance problem without any schema changes. -- uberSVN: Apache Subversion Made Easy http://www.uberSVN.com
