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

--- Comment #13 from Max Semenik <maxsem.w...@gmail.com> 2012-04-23 17:43:35 
UTC ---
Another issue:
> $xares = $dbr->select( "revision", array('rev_id', 'rev_timestamp'), 
> array("rev_page=$pg_id"), __METHOD__, array("ORDER BY"=>"rev_id DESC") );

rev_id is not guaranteed to always behave like you want it to, sort by
rev_timestamp.

(Expanding on comment #12)

> Then it's not going to be deployed on WMF, because requesting thousands of
> revisions is not an option with our scale.

Even caching isn't going to help, because we have pages with *hundreds of
thousands* revisions. Memcached object size limit is 1MB - revision information
for such pages won't even fit into it. And Special:Timemap will get tired of
serving megabytes and megabytes of data in such cases.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
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