Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Performance of certain query patterns is degradated #434

Open
5 tasks
D063520 opened this issue Dec 3, 2023 · 0 comments
Open
5 tasks

Performance of certain query patterns is degradated #434

D063520 opened this issue Dec 3, 2023 · 0 comments
Labels
bug Something isn't working

Comments

@D063520
Copy link
Contributor

D063520 commented Dec 3, 2023

Part of the endpoint? (leave empty if you don't know)

  • Backend (qendpoint-backend)
  • Store (qendpoint-backend)
  • Core (qendpoint-core)
  • Frontend (qendpoint-frontend)
  • Other

Description of the issue

My theory is that queries in WDBench that contain triple patterns with disjoint variables are timing out, example:

query 171,

SELECT * WHERE { 
?x3 <http://www.wikidata.org/prop/direct/P1082> ?x4 . 
?x6 <http://www.wikidata.org/prop/direct/P1448> ?x3 . 
?x1 <http://www.wikidata.org/prop/direct/P31> <http://www.wikidata.org/entity/Q6256> . 
?x1 <http://www.wikidata.org/prop/direct/P36> ?x7 . 
?x1 <http://www.wikidata.org/prop/direct/P1448> ?x5 . 
?x1 <http://www.wikidata.org/prop/direct/P1082> ?x2 . 
 } LIMIT 100000

query 183

SELECT * WHERE { ?x1 <http://www.wikidata.org/prop/direct/P115> ?x2 . ?x1 <http://www.wikidata.org/prop/direct/P31> <http://www.wikidata.org/entity/Q476028> . ?x3 <http://www.wikidata.org/prop/direct/P625> ?x3 . ?x2 <http://www.wikidata.org/prop/direct/P625> ?x4 . 
 } LIMIT 100000

query 209

SELECT * WHERE {
 ?x1 <http://www.wikidata.org/prop/direct/P131> <http://www.wikidata.org/entity/Q9899> . 
?x1 <http://www.wikidata.org/prop/direct/P31> <http://www.wikidata.org/entity/Q79007> . 
?x2 <http://www.wikidata.org/prop/direct/P625> ?x2 . 
 } LIMIT 100000

The disjoin part seams to resolve fast enough. This seams to affect many of the queries with timeout!

Excepted behavior

No response

Obtained behavior

No response

How to reproduce

No response

Endpoint version

No response

Do I want to contribute to fix it?

None

Something else?

No response

@D063520 D063520 added the bug Something isn't working label Dec 3, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant