clintropolis commented on PR #15366: URL: https://github.com/apache/druid/pull/15366#issuecomment-1830873969
> btw how do the benchmark numbers look like if you disable bitmap indexes? ok re-ran benchmarks (my laptop a bit busier this time than last time so stuff a bit slower) expression filter: ``` Benchmark (query) (rowsPerSegment) (schema) (vectorize) Mode Cnt Score Error Units SqlExpressionBenchmark.querySql 38 5000000 auto false avgt 5 5135.236 ± 77.511 ms/op ``` arrayContainsElement filter (indexes commented out): ``` Benchmark (query) (rowsPerSegment) (schema) (vectorize) Mode Cnt Score Error Units SqlExpressionBenchmark.querySql 38 5000000 auto false avgt 5 5140.199 ± 141.967 ms/op ``` arrayContainsElement filter (with indexes): ``` Benchmark (query) (rowsPerSegment) (schema) (vectorize) Mode Cnt Score Error Units SqlExpressionBenchmark.querySql 38 5000000 auto false avgt 5 149.909 ± 2.783 ms/op ``` -- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
