diff options
| author | Brion Vibber <brion@pobox.com> | 2010-04-01 10:15:40 -0700 |
|---|---|---|
| committer | Brion Vibber <brion@pobox.com> | 2010-04-01 10:17:17 -0700 |
| commit | f1c01f9ead4a5f4da7c6964f0998831fa31f8a16 (patch) | |
| tree | 05ea946e7ff7c09996fa2d758637858e7c05db9c /doc-src | |
| parent | d60c1f1a9f343f10d33800862c67839594607c8f (diff) | |
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.
Diffstat (limited to 'doc-src')
0 files changed, 0 insertions, 0 deletions