https://bugzilla.wikimedia.org/show_bug.cgi?id=24479

Roan Kattouw <roan.katt...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |roan.katt...@gmail.com

--- Comment #4 from Roan Kattouw <roan.katt...@gmail.com> 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: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to