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

--- Comment #1 from Reedy <[email protected]> 2011-05-13 21:27:33 UTC ---
--
-- Track interlanguage links
--
CREATE TABLE /*_*/langlinks (
  -- page_id of the referring page
  ll_from int unsigned NOT NULL default 0,

  -- Language code of the target
  ll_lang varbinary(20) NOT NULL default '',

  -- Title of the target, including namespace
  ll_title varchar(255) binary NOT NULL default ''
) /*$wgDBTableOptions*/;

CREATE UNIQUE INDEX /*i*/ll_from ON /*_*/langlinks (ll_from, ll_lang);
CREATE INDEX /*i*/ll_lang ON /*_*/langlinks (ll_lang, ll_title);



It seems we're probably missing an index or 2 to be able to do do all these
possible combinations nicely...

Though, looking at the IWBacklinks module, if you're wanting to filter on
title, you've got to provide a prefix (in this case language)


Probably not going to be that bad, by putting some common restrictions

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to