The Knowledge Graph Conference Icon
The Knowledge Graph Conference
  • 馃彔Home
  • 馃搮Events
  • 馃懁Members
  • 馃數Announcements
  • 馃數Ask
  • 馃數Ask The Ontologists
  • 馃數Events
  • 馃數Jobs
  • 馃數Promotions
  • 馃數Share
Powered by Tightknit
Ask
Ask

Timeout Issues with SPARQL Queries in AWS Neptune

Avatar of nabeelnabeel
路Jan 03, 2022 11:58 PM

has anyone else run into a lot of timeout issues when making analytical SPARQL queries in AWS Neptune? So like counting all triples or deleting all triples with a certain predicate? Our db has 100s million triples I鈥檇 say

10 comments

路 Sorted by Oldest
  • Avatar of nabeel
    nabeel
    路

    hard to know exact given everytime i try to count it times out

  • Avatar of Fran莽ois S.
    Fran莽ois S.
    路

    Charles I. Ora L.

  • Avatar of Ora L.
    Ora L.
    路

    https://docs.aws.amazon.com/neptune/latest/userguide/parameters.html

  • Avatar of Nicole B.
    Nicole B.
    路

    without knowing more about what you鈥檙e working with - two things I needed to do with working with a db that was about 12B were 1. optimize queries and 2. upgrade our cluster. that said timeout was still an issue.

  • Avatar of nabeel
    nabeel
    路

    so my query was just a simple count all triples in the database

    SELECT (COUNT(?s) AS ?triples) WHERE { ?s ?p ?o }
  • Avatar of nabeel
    nabeel
    路

    our cluster is a db.r5.large

  • Avatar of nabeel
    nabeel
    路

    so i bumped up my cluster size and timeout parameter and still running into issues

  • Avatar of nabeel
    nabeel
    路

    for pretty simple like count queries

  • Avatar of nabeel
    nabeel
    路

    so now running db.r5.xlarge

  • Avatar of Charles I.
    Charles I.
    路

    nabeel could you raise a support ticket and we can try to assist through the proper channels?