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)