This message was deleted.
# community-help
s
This message was deleted.
k
Can you try using just
:
instead of
:=
in the query just to check the difference in perf? E.g.
Copy code
account_id:${accountId} || sharer_account_ids:${accountId} || admin_account_ids:${accountId}
d
@Kishore Nallan sorry for taking so long to respond, been out sick! We have tried both ways with
:
and
:=
and both gave the same 503 error. The only thing that seems to help the query work is either adding a specific search term rather than
*
or removing some of the account id filters, so only
account_id:${accountId}
for instance. Unfortunately we need the option to get all results though (so we can't force a search term) and we need to be able to filter by these IDs
k
Hope you are feeling better now. What version of Typesense are you using?
d
We are self-hosting Typesense with this image version
typesense/typesense:0.26.0.rc24
and we just upgraded to the package version
1.8.0-0
k
rc24 is a bit old. Can you try on 0.26.0.rc40?
Oh wait the issue is probably sort by name
That's going to be pretty expensive. String sorting doesn't really work well on large candidate sets.
d
How large of a set of data would you expect it to not work well around?
It's also odd because it works well in our env with around ~43k records, but fails in another env with ~16k records
k
Hmm 16K should certainly be fine.
Would you be able to share the dataset with us? Before that please try on latest RC i mentioned above
d
Potentially, I'd have to check with my team! I will try some stuff on my end first before (including updating to the latest). Thank you
👍 1