Public

Project privacy set to public. By default, its content is available to everyone (authenticated or not). Please note that more restrictive permissions might exist on some items.

stable

Clone or download

Read-only

request #12578: Slow git repositories listing

Download Browse

Some index are missing in order to achieve acceptable performances in git repositories listing. On live database, request to fetch repositories ordered by push date gains a 10× boost (0.30s → 0.03s). I suggest that we introduce dropIndex in ForgeUpgrade for future usage. Change-Id: I84fdca4cfdb4fc7643e6b3f47c9a203c4d71a454

+74 −3
Nicolas Terray (nterray) 2018-12-06 14:24
Nicolas Terray (nterray) 2018-12-06 14:24
6ce7c993edd345ddc211cf05b58d1359c870bb8b
4742fd8ceb54991acf0501b03b5eaf7857a783bd
git #tuleap/stable/6ce7c993edd345ddc211cf05b58d1359c870bb8b

Modified Files

Side by side diff
Inline diff
Name
M plugins/git/db/install.sql +5 −3 Go to diff View file
A plugins/git/db/mysql/updates/2018/201812061206_add_index_to_sort_git_repo_alphabetically.php +69 −0 Go to diff View file