]> 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:17:17 +0000 (10:17 -0700)
commitf1c01f9ead4a5f4da7c6964f0998831fa31f8a16
tree05ea946e7ff7c09996fa2d758637858e7c05db9c
parentd60c1f1a9f343f10d33800862c67839594607c8f
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