Last modified: 2012-08-26 09:36:06 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 4699 - Querypage shouldn't use LIMIT for paging but "title >= x AND namespace >= y"
Querypage shouldn't use LIMIT for paging but "title >= x AND namespace >= y"
Status: NEW
Product: MediaWiki
Classification: Unclassified
Special pages (Other open bugs)
All All
: Low enhancement with 5 votes (vote)
: ---
Assigned To: Nobody - You can work on this!
Depends on:
Blocks: 2415 39661
  Show dependency treegraph
Reported: 2006-01-21 02:21 UTC by Ævar Arnfjörð Bjarmason
Modified: 2012-08-26 09:36 UTC (History)
3 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Description Ævar Arnfjörð Bjarmason 2006-01-21 02:21:04 UTC
Querypage (and by extension classes that inherit it) shouldn't use LIMIT to do
paging as this gets exponentially more expensive the further into the set one
goes, it should use shomething like title >= x AND namespace => y like
Special:Contributions does. This would allow raising the number of rows inserted
into `querycache` for a given page without it bogging down the server(s).
Comment 1 lɛʁi לערי ריינהארט 2006-02-09 12:04:32 UTC
1) A "nice to have" feature would be a "from=" parameter which should be
supported in wiki syntax [[special:foo/bar]].
2) See:
Bug 4927: User interface should substitute "_" consistently with space (%20) in
the from= parameter
3) trivial: The parameters should be supported in the user interface.
Comment 2 lɛʁi לערי ריינהארט 2006-02-09 23:10:55 UTC
addition to comment #1
4) Support both "from=<pagename>" and "namespace=<namespace>" with wiki syntax
Comment 3 lɛʁi לערי ריינהארט 2006-02-10 01:15:59 UTC
(In reply to comment #2)
> addition to comment #1
> 4) Support both "from=<pagename>" and "namespace=<namespace>" with wiki syntax
> [[special:foo/<namespace>:<pagename>]]

This is the subject of
Bug 4944: Support both "from=<pagename>" and "namespace=<namespace>" with wiki
syntax [[special:foo/<namespace>:<pagename>]]
Comment 4 Riley Lynch 2007-01-22 16:52:41 UTC
I submitted a patch for Bug 2415 which accomplishes paging without the use of LIMIT.

Note You need to log in before you can comment on or make changes to this bug.