Brad Jorsch schreef:
On Fri, Feb 13, 2009 at 09:29:51PM +0100, Roan Kattouw
wrote:
Are there any other modules left you signaled
paging issues for?
There's still the question about whether the SQL query for
prop=duplicatefiles can have i2.img_name added to the ORDER BY without
blowing up MySQL.
I talked to Domas, and it appears MySQL doesn't support the hybrid
sorting (first by index, then filesort to break ties) I alluded to
earlier. Maybe that an index on (img_sha1, img_name) will make it
possible, I'll investigate that tomorrow.
And there's extlinks and exturlusage, but I think
nothing can be done
about them due to the impossibility of using any index for sorting the
el_to or el_index columns (MySQL requires an index on a blob column to
specify a prefix length, and the total length of the index key can be
only 256).
Yeah, that sucks. Guess we'll just have to accept that for those two
modules.
Roan Kattouw (Catrope)