Last modified: 2011-07-13 02:52:15 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 T23675, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 21675 - Filter Special:NewPages to subpages of a given page
Filter Special:NewPages to subpages of a given page
Status: NEW
Product: MediaWiki
Classification: Unclassified
General/Unknown (Other open bugs)
unspecified
All All
: Low enhancement (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2009-11-28 19:33 UTC by Cenarium
Modified: 2011-07-13 02:52 UTC (History)
3 users (show)

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


Attachments

Description Cenarium 2009-11-28 19:33:31 UTC
Provide a way to filter Special:NewPages to subpages of a given page. It could be useful for example to see new articles for deletion discussions and for other processes relying on subpages of a main page. There are also some projects heavily using subpages for content which could benefit from this.

It can be only a url option if it can't be neatly included in the interface - we can always link to it.
Comment 1 Roan Kattouw 2009-11-28 22:31:31 UTC
If this were to be implemented, the only efficient way to do it would be by sorting by page name instead of by timestamp, which would be of limited use (although of course Newpages only has one entry for each page, so it's not that big a deal).
Comment 2 Jan Piotrowski 2011-07-04 09:36:22 UTC
Why would sorting by page name be needed? A filter to consider only parts of all pages, in this case Subpages of a specific name, seems like a reasonable request.
Comment 3 Roan Kattouw 2011-07-04 09:45:28 UTC
(In reply to comment #2)
> Why would sorting by page name be needed? A filter to consider only parts of
> all pages, in this case Subpages of a specific name, seems like a reasonable
> request.
Sorting by page name is needed because that's the way how database indexing works. Doing a prefix filter on the page name while sorting by timestamp is guaranteed to be inefficient on large tables. It's impossible to add an index that will optimize that.
Comment 4 Jan Piotrowski 2011-07-04 11:45:58 UTC
(In reply to comment #3)
> Sorting by page name is needed because that's the way how database indexing
> works. Doing a prefix filter on the page name while sorting by timestamp is
> guaranteed to be inefficient on large tables. It's impossible to add an index
> that will optimize that.
Didn't think about that. So I assume what you mean is that a (MySQL) LIKE-Search on page_title when ordered by page_touched isn't an option?
Comment 5 Roan Kattouw 2011-07-04 19:14:53 UTC
(In reply to comment #4)
> Didn't think about that. So I assume what you mean is that a (MySQL)
> LIKE-Search on page_title when ordered by page_touched isn't an option?
Assuming an index on (page_title, page_touched):
(I don't believe such an index actually exists.)

WHERE page_title = 'Foo' ORDER BY page_touched; --GOOD
WHERE page_title LIKE 'Foo%' ORDER BY page_touched; --BAD
WHERE page_title LIKE 'Foo%' ORDER BY page_title, page_touched; --GOOD
Comment 6 Jan Piotrowski 2011-07-04 22:37:36 UTC
(In reply to comment #5)
> Assuming an index on (page_title, page_touched):
> (I don't believe such an index actually exists.)
> 
> WHERE page_title = 'Foo' ORDER BY page_touched; --GOOD
> WHERE page_title LIKE 'Foo%' ORDER BY page_touched; --BAD
> WHERE page_title LIKE 'Foo%' ORDER BY page_title, page_touched; --GOOD

There is only an index 'name_title' that is on page_namespace + page_title (only have 1.15.1 around right now). 

So no matter how we try, there is no way to make a well performing "Page starts with"-search ordered by last edit date?
Comment 7 Roan Kattouw 2011-07-13 02:52:15 UTC
(In reply to comment #6)
> So no matter how we try, there is no way to make a well performing "Page starts
> with"-search ordered by last edit date?
No.

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


Navigation
Links