Slow Elasticsearch queries
-
Hello.
I have an issue with very slow elasticsearch queries...
if i try to find a user by loginId or userID the reponse takes about 300ms
if i query the elasticsearch engine dierctly, also fast reponse
BUT, if i query fusionauth search with a querystring param. very slow response (~8 to 10 seconds)
here is my config:
Ideas?
-
Hi @luke-fishman,
I have a few questions for you to see if we can get to the bottom of this.
Is this an ongoing problem or has it recently surfaced? If recently surfaced, has anything changed which would slow your queries down? For instance, have you made any architecture changes? Was this user query much faster in the recent past?
What do queries from the Admin UI look like (are they performant?)?
Other things to evaluate include the size of your database and your architecture to make sure it's right-sized for your use case.
Finally, are you seeing anything in the error and event logs in FusionAuth (or in your server) that would indicate a larger problem?
Thanks,
Josh
