-
Notifications
You must be signed in to change notification settings - Fork 22
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Add performance support for JSON_MATCH_ANY on S2 8.0+ #58
Comments
Hi @harisenbon |
Yeah, I thought so too ;) I would love to use , |
I just had a chance to test this thing.
Looks like
@harisenbon Can you please clarify, what version of SingleStore are you using and what the schema/size of your JSON data is? Probably, this performance degradation happens only in some specific cases. |
Hey all,
I'm working with the S2 team, and we've run into huge performance issues when querying on multiple JSON fields in S2 (see Support ticket #27009)
Example:
With the JSON improvements in version 8, we can replace that with something like this, which runs at 1.25s without load:
However, the Laravel driver doesn't currently support
JSON_MATCH_ANY
out of the box.I've gotten it working on my system, using the following changes to
SingleStore\Laravel\Query\Grammar
Functions to determine if we should use this new code:
We then create a function to wrap the default query with
JSON_MATCH_ANY
, swapping inMATCH_PARAM_*
for the colum:Finally, we apply the override to each
where*
function that we want support for:Let me know if a PR would be preferred.
The text was updated successfully, but these errors were encountered: