Pulquero added a comment.

  That is a shame, I've been making improvements to really give the other 
stores a run for their money. Well, for reference, the results so far are that 
in a single-box configuration, the current dump requires <1.5TB of disk space 
loaded. And a preliminary test of the difficult query below without full 
optimisations enabled, was taking around ~minutes to execute (I'm in the 
process of testing it properly).
  
  PREFIX wd: http://www.wikidata.org/entity/
  PREFIX wdt: http://www.wikidata.org/prop/direct/
  PREFIX rdfs: http://www.w3.org/2000/01/rdf-schema#
  SELECT ?person ?name (COUNT(?profession) AS ?count) WHERE {
  
    ?person wdt:P31 wd:Q5 .
    ?person wdt:P106 ?profession .
    ?person rdfs:label ?name .
    FILTER (LANG(?name) = "en")
  
  }
  GROUP BY ?person ?name
  ORDER BY DESC(?count)
  LIMIT 100

TASK DETAIL
  https://phabricator.wikimedia.org/T289621

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Pulquero
Cc: MPhamWMF, Pulquero, Hannah_Bast, nguyenm9, Smalyshev, Aklapper, 
Lucas_Werkmeister_WMDE, Gehel, Andrawaag, Addshore, Susannaanas, Akuckartz, 
TomT0m, Jecummings4, Krabina, So9q, Salgo60, WMDE-leszek, GreenReaper, 
Ostrzyciel, Samantha_Alipio_WMDE, Tagishsimon, Lydia_Pintscher, DanBri, 
Jneubert, Ivanhercaz, TheKtk, Justin0x2004, Afandian, Sj, TallTed, Tpt, 
Thadguidry, Hjfocs, Mohammed_Sadat_WMDE, MarioGom, karapayneWMDE, Majavah, 
Jerven, Astuthiodit_1, BeautifulBold, Suran38, Invadibot, Jtm-lis, maantietaja, 
Peteosx1x, NavinRizwi, CBogen, ItamarWMDE, Isaacandy, Demian, Olson.jared.m, 
Nandana, Namenlos314, Lahi, Gq86, Bryandamon, GoranSMilovanovic, QZanden, 
EBjune, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, 
Steko, Samwilson, PhotographerTom, suriyaa, Psychoslave, tosfos, jkroll, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Darenwelsh, Dinoguy1000, 
Manybubbles, brion, Mbch331, MarkAHershberger
_______________________________________________
Wikidata-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to