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

Sergey Vladimirov <vlser...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |vlser...@gmail.com

--- Comment #1 from Sergey Vladimirov <vlser...@gmail.com> ---
There is a very serious problem with offset parameter. "offset" parameter means
not key/value offset, but rather row number offset. Because of that it is
possible to create queries that creates full-index-scans using large offset
values.

Current state-of-art is usage of values anchor, not pages (even in mediawiki
API). It may be entity id anchor or claim id anchor.

See also: 
- details of doModifyLimitQuery implementation for MySQL:
http://www.doctrine-project.org/api/dbal/2.1/source-class-Doctrine.DBAL.Platforms.MsSqlPlatform.html#_doModifyLimitQuery

-- 
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