databend icon indicating copy to clipboard operation
databend copied to clipboard

performance issue: BITMAP_INTERSECT ... functions

Open BohuTANG opened this issue 1 month ago • 1 comments

Summary

Multiple executions of the same BITMAP_INTERSECT query show consistent execution times when data being cached on local disk.

Query:

SELECT
    TO_STRING(BITMAP_INTERSECT(frame_bitmap))
FROM
    frame_bitmap_table

Image

These also need to address:

Image

BohuTANG avatar Nov 25 '25 09:11 BohuTANG

part of:

  • [x] bitmap_intersect: https://github.com/databendlabs/databend/pull/19041

todo:

  • [ ] Benchmark covering all bitmap-related functions: https://github.com/databendlabs/databend/pull/19069
  • [ ] https://github.com/databendlabs/databend/issues/19101

KKould avatar Dec 03 '25 08:12 KKould