https://bugzilla.wikimedia.org/show_bug.cgi?id=26872

Roan Kattouw <roan.katt...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |roan.katt...@gmail.com

--- Comment #3 from Roan Kattouw <roan.katt...@gmail.com> 2011-01-24 02:23:00 
UTC ---
(In reply to comment #2)
> Somebody who has knowledge about how mysql handles indices needs to look into
> this. I don't know if MySQL is able to merge three indices to make the 
> required
> query sane.
There is no such thing as merging indices.

There is an index on (img_user_text, img_timestamp), we could use that.
However, we'd have to sort and page by timestamp instead of name (kind of
annoying since timestamps aren't necessarily unique), and we couldn't support
any other limiting parameters (aisha1, aiprefix, etc.) in combination with
aiuser.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to