search

nickdrummond / star-wars-ontology

An OWL ontology describing events, characters and places in the Star Wars Universe
https://nickdrummond.github.io/star-wars-ontology/
3 stars 1 forks source link

Slow queries on heroku #27

Closed nickdrummond closed 2 years ago

nickdrummond commented 2 years ago

Some queries run a little slow on the limited memory the heroku dyno has.

These time out on AJAX calls no matter how many times they are requested and return 0 results. Should show a timeout error on the UI for starters. Should be able to tweak the timeout. Perhaps think about caching results too (as a few common ones will be used a lot)?

eg

Planet and locationOf some (Event and participant value Ahsoka_Tano)
nickdrummond commented 2 years ago

Takes about 12s on laptop

nickdrummond commented 2 years ago

Implemented retries, better error and timeout handling. Basic caching on server and refresh for reasoner and cache