Stream: hapi
Topic: Searching
Andrew Broadbent (Jan 10 2017 at 17:01):
Hi there, I'm just looking for some advice on searching a hapi database. I'm just trying to test out what works and as part of it I've performed the query '{{URL}}/Basic?_profile=http://stelar.org/StructureDefinition/stelar/profile/questionResponse', where we have about 370000 instances of basic. The result is a 504 timeout however. How do I increase the timeout time? Is there a way to increase the performance of the query? I'm not actually sure if it's trying to return all the matching resources, or just their id's, but either would be fine
James Agnew (Jan 15 2017 at 17:31):
Hi @Andrew Broadbent,
This is something we're actively working on... Right now, one limitation of HAPI's JPA design is that it loads all results for your search into a staging table before returning. If you have a query that returns 300k results that is definitely going to be slow. We have a bunch of code in progress to address this limitation, so hopefully that will get a lot faster in the next release.
Andrew Broadbent (Jan 16 2017 at 16:27):
@James Agnew Thanks for the update. Any idea on a rough time frame for that?
James Agnew (Jan 18 2017 at 19:45):
Hi Andrew,
I don't have a precise timeline yet, but certainly within the next few months.
Last updated: Apr 12 2022 at 19:14 UTC
