]> git.mxchange.org Git - quix0rs-gnu-social.git/commit
Temporary hack until notice_profile_id_idx is updated
authorBrion Vibber <brion@pobox.com>
Thu, 1 Apr 2010 17:15:40 +0000 (10:15 -0700)
committerBrion Vibber <brion@pobox.com>
Thu, 1 Apr 2010 17:15:40 +0000 (10:15 -0700)
commit9f2cfd20f80fbeadd59b0f9a153be0b9f0799fae
tree47f3b0bde0bbda9e11324f9fdccca46964ac7c96
parent3ed88938b95804ecadc62ed3a5f61a0863e2ff78
Temporary hack until notice_profile_id_idx is updated
to (profile_id, id) instead of (profile_id, created, id).
It's been falling back to PRIMARY instead, which is really
very inefficient for a profile that hasn't posted in a few
months. Even though forcing the index will cause a filesort,
it's usually going to be better. Even for large profiles it
seems much faster than the badly-indexed query.
classes/Profile.php