Roan Kattouw <> changed:

           What    |Removed                     |Added
                 CC|                            |

--- Comment #4 from Roan Kattouw <> 2010-11-29 22:05:56 
UTC ---
The query for listing revisions by path does something like WHERE cp_repo_id=1
AND cp_path LIKE '/trunk%' ORDER BY cp_rev_id DESC . If my understanding about
how the code_paths table works is correct (will confirm in the morning), we
should be able to convert that to AND cp_path='/trunk' , introduce an index on
(cp_repo_id, cp_path, cp_rev_id) and that should make this query happy.

Configure bugmail:
------- You are receiving this mail because: -------
You are on the CC list for the bug.

Wikibugs-l mailing list

Reply via email to