| • bzimport | |
| Nov 4 2006, 10:19 AM |
| F3393: LinkSearchNamespace.patch | |
| Nov 21 2014, 9:28 PM |
Author: wiki.bluefish
Description:
It would be nice if the output of Spezial:Linksearch can be filtered for the
different namespaces.
e.g. show only the article name space of
http://de.wikipedia.org/wiki/Spezial:Linksearch/%2A.dyndns.org
Version: unspecified
Severity: enhancement
Hopefully this isn't an index problem; on very often-linked sites, picking a rarely appearing namespace
could require shuffling through the entire link set in the database.
Namespace filter added with r20144
(In reply to comment #1)
Created an attachment (id=2635) [edit]
Adds a namespace selector to Special:Linksearch
Have seen your patch too late. But it works similiar
(In reply to comment #2)
Hopefully this isn't an index problem; on very often-linked sites, picking a
rarely appearing namespace
could require shuffling through the entire link set in the database.
If you are unhappy with this implementation, please revert. Another not so
expensive (hopefully) solution is a simple filter main namespace and non main
namespace.
wiki.bluefish wrote:
thanks for adding the filter, but is has a bug. If you choose talk pages as
filter it shows only talk pages but if you click on "next 50" or "show 500" then
the parameter "namespace=x" is missing in the link.
(In reply to comment #4)
thanks for adding the filter, but is has a bug. If you choose talk pages as
filter it shows only talk pages but if you click on "next 50" or "show 500" then
the parameter "namespace=x" is missing in the link.
Fixed with r20159
wiki.bluefish wrote:
(In reply to comment #5)
(In reply to comment #4)
thanks for adding the filter, but is has a bug. If you choose talk pages as
filter it shows only talk pages but if you click on "next 50" or "show 500" then
the parameter "namespace=x" is missing in the link.Fixed with r20159
it isn't fixed. i can reproduce this behaviour. please fix. thx
It is fixed, but the Wikimedia servers are still on release r20145 (see
[[Special:Version]]. A bigger schema change is pending. Be patient please :-)
wiki.bluefish wrote:
(In reply to comment #9)
for the record, reverted, non-trivial optimization to make it happen.
but in general it worked very fine. (i was already wondering why it since some
minutes don't work at all..)
wiki.bluefish wrote:
so we have a namespace filter in Special:Contributions, in Special:Recentchanges
and in Special:Watchlist (and more?) but it is not possible in
Special:Linksearch? hardly understandable.
le.korrigan wrote:
Shouldn't this bug be reopened ? This feature doesn't seem to be activated on WMF wikis so far.
ayg wrote:
See comment #11. The feature exists but has not been activated because it's inefficient due to the structure of the table: the table contains an article ID only, with no namespace stored.
I admit I don't see the inefficiency in the join:
mysql> EXPLAIN SELECT * FROM externallinks WHERE el_index LIKE 'http://com.disney%';
+----+-------------+---------------+-------+---------------+----------+---------+------+------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+---------------+-------+---------------+----------+---------+------+------+-------------+
| 1 | SIMPLE | externallinks | range | el_index | el_index | 62 | NULL | 4 | Using where | |
+----+-------------+---------------+-------+---------------+----------+---------+------+------+-------------+
1 row in set (0.00 sec)
mysql> EXPLAIN SELECT * FROM externallinks JOIN page ON (el_from = page_id) WHERE page_namespace = 0 AND el_index LIKE 'http://com.disney%';
+----+-------------+---------------+--------+--------------------+----------+---------+------------------------------+------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+---------------+--------+--------------------+----------+---------+------------------------------+------+-------------+
| 1 | SIMPLE | externallinks | range | el_from,el_index | el_index | 62 | NULL | 4 | Using where | |
| 1 | SIMPLE | page | eq_ref | PRIMARY,name_title | PRIMARY | 4 | wikidb.externallinks.el_from | 1 | Using where | |
+----+-------------+---------------+--------+--------------------+----------+---------+------------------------------+------+-------------+
2 rows in set (0.00 sec)
But that's another bug. Feel free to open a new bug requesting that this feature be improved to be efficient enough for inclusion on Wikipedia.