samuelcolvin commented on issue #7845:
URL:
https://github.com/apache/arrow-datafusion/issues/7845#issuecomment-2061121332
tiny update to my example above, I realised there’s a much better comparison
query:
```sql
-- datafusion
SELECT count(*) FROM records where json_contains(attributes, 'size');
-- 6165747 in 18.0s
-- datafusion
SELECT count(*) FROM records where attributes like '%"size":%';
-- 6165747 in 15.4s
-- datafusion
SELECT count(*) FROM records where attributes ilike '%"size":%';
-- 6165747 in 22.6s
```
so even unoptimised, jiter is only 16% slower than `like` and already faster
than `ilike`.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
