RE: svn commit: r28624 - branches/issue-2897/subversion/libsvn_fs_util

>> > + "mergedrevend, inheritable, mergedfrom, "
>> > + "mergedto FROM mergeinfo_changed "
>> > + "WHERE revision between ? AND ? "
>> > + "ORDER BY revision ASC, mergedto ASC; ",
>> > + pool));
>>
>> This will iterate over *every* mergeinfo change *everywhere* in the
>> repository between the two revisions. I can't imagine that this is
>> efficient for large multi-project multi-branch repositories.

>Actually, can't you make this issue a little better by putting LIKEs
>on mergedto and mergedfrom?

No, I can not, as the paths I have here are child paths which are longer than the parents, so LIKE won't work.

May be I can generate dynamic where clause something like
Data:
mergedto = '/a/b/c/d/e/f/g'

Dynamic where clause:
'where mergedfrom in ('/a', '/a/b', '/a/b/c', '/a/b/c/d', '/a/b/c/d/e', '/a/b/c/d/e/f', '/a/b/c/d/e/f/g')'.

With regards
Kamesh Jayachandran
Received on Sat Dec 22 19:51:26 2007