[Wikidata-bugs] [Maniphest] T167361: Queries involve finding strings (e.g. labels, descriptions or aliases) in a language are slow

[Nikki]

Nikki added a comment.


  QLever is able to handle certain queries like these, e.g. 
https://qlever.cs.uni-freiburg.de/wikidata/nF1iKM (one of the queries mentioned 
in the description) gave me the results in under a second, whereas the same 
query in Blazegraph times out.
  
  It only supports the syntax `filter (lang(?variable) = "..."))` though.

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

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

To: Nikki
Cc: Manuel, Esc3300, Ijon, Lucie, daniel, Smalyshev, Nikki, Aklapper, 
Danny_Benjafield_WMDE, mrephabricator, Astuthiodit_1, AWesterinen, bking, 
karapayneWMDE, Invadibot, MPhamWMF, maantietaja, ItamarWMDE, Akuckartz, ET4Eva, 
Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, 
Mahir256, QZanden, EBjune, srishakatux, merbst, LawExplorer, Avner, Gehel, 
_jensen, rosalieper, Scott_WUaS, Jonas, FloNight, Xmlizer, jkroll, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

[Wikidata-bugs] [Maniphest] T167361: Queries involve finding strings (e.g. labels, descriptions or aliases) in a language are slow

[Esc3300]

Esc3300 added a project: Language codes.

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

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

To: Esc3300
Cc: Esc3300, Ijon, Lucie, daniel, Smalyshev, Nikki, Aklapper, Invadibot, 
MPhamWMF, maantietaja, CBogen, Akuckartz, ET4Eva, Nandana, Namenlos314, Lahi, 
Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, Mahir256, QZanden, EBjune, 
merbst, LawExplorer, Avner, Gehel, _jensen, rosalieper, Scott_WUaS, Jonas, 
FloNight, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, 
Manybubbles, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

[Wikidata-bugs] [Maniphest] T167361: Queries involve finding strings (e.g. labels, descriptions or aliases) in a language are slow

[Esc3300]

Esc3300 added a comment.


  Maybe we should move from 
  *` ?item rdfs:label "text"@en `
  To
  *`?item wikibase:label "text"`
  *`"text" schema:inLanguage "en"`
  This may look like it would double the number of triples, but it happens that 
"text" is the same for several languages.
  
  Also, this would simplify analysis on unique labels, e..g T286257#7212146 


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

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

To: Esc3300
Cc: Esc3300, Ijon, Lucie, daniel, Smalyshev, Nikki, Aklapper, Invadibot, 
MPhamWMF, maantietaja, CBogen, Akuckartz, ET4Eva, Nandana, Namenlos314, Lahi, 
Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, 
LawExplorer, Avner, Gehel, _jensen, rosalieper, Scott_WUaS, Jonas, FloNight, 
Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

[Wikidata-bugs] [Maniphest] T167361: Queries involve finding strings (e.g. labels, descriptions or aliases) in a language are slow

[Nikki]

Nikki added a comment.


  This is also a problem for monolingual text statements, lemmas, forms and 
senses.
  
  Other things I've tried to do which have timed out:
  
  - Find all statements using the language code `mis` and check whether they 
have a qualifier specifying the actual language.
  - List language codes and the number of times they've been used for forms, 
grouped by language (like this table 

 but for forms, not lemmas).
  - Find items which have a label in a particular language and a `P279` 
(subclass of) statement, where the label starts with a capital letter so I can 
check whether they should be fixed.

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

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

To: Nikki
Cc: Ijon, Lucie, daniel, Smalyshev, Nikki, Aklapper, MPhamWMF, CBogen, 
Akuckartz, ET4Eva, Nandana, Namenlos314, Lahi, Gq86, Darkminds3113, 
Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, 
LawExplorer, Avner, Gehel, _jensen, rosalieper, Scott_WUaS, Jonas, FloNight, 
Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] T167361: Queries involve finding strings (e.g. labels, descriptions or aliases) in a language are slow

[Nikki]

Nikki renamed this task from "Queries involve finding labels, descriptions or 
aliases for a language are slow" to "Queries involve finding strings (e.g. 
labels, descriptions or aliases) in a language are slow".

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

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

To: Nikki
Cc: Ijon, Lucie, daniel, Smalyshev, Nikki, Aklapper, CBogen, Akuckartz, ET4Eva, 
Nandana, Namenlos314, Lahi, Gq86, Darkminds3113, Lucas_Werkmeister_WMDE, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, Avner, Gehel, _jensen, 
rosalieper, Scott_WUaS, Jonas, FloNight, Xmlizer, jkroll, Wikidata-bugs, 
Jdouglas, aude, Tobias1984, Manybubbles, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs