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

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T6699, the corresponding Phabricator task for complete and up-to-date bug report information.
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)
1.11.x
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: ---


Attachments

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
[[special:foo/<namespace>:<pagename>]]
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.


Navigation
Links