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

merl <bugrepor...@to.mabomuja.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |bugrepor...@to.mabomuja.de

--- Comment #25 from merl <bugrepor...@to.mabomuja.de> ---
I also need to have all namespace names of all wikis in one table on each
cluster.

One aditional use case in my script is replacing full page titles of
languagelinks, iwlinks and wikidata-sitelink table with namespace id and title
without namespace as is needed for further queries in this script on page
table.

Doing this at application layer would be very inefficient any slow, because i
am doing this with about 6,5 million pages (all living people) twice a day.
Currently this part of my tools is done on toolserver with joining
namespacename in less than 5 minutes.

Running api queries to get this namespace info for all 500 wikis (wikipedia +
commons + wikisource + wikiquote) would take longer. And running 6.5 mio.
single update queries on a use table instead of one join would also stress the
database server needless.

So the solution for me is to create this table for my own.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to