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:15:40 -0700 |
| commit | 9f2cfd20f80fbeadd59b0f9a153be0b9f0799fae (patch) | |
| tree | 47f3b0bde0bbda9e11324f9fdccca46964ac7c96 /avatar | |
| parent | 3ed88938b95804ecadc62ed3a5f61a0863e2ff78 (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 'avatar')
0 files changed, 0 insertions, 0 deletions