Skip to content

Improve performance of contains expression #2972

@andygrove

Description

@andygrove

What is the problem the feature request solves?

CometStringExpressionBenchmark shows poor performance for contains:

OpenJDK 64-Bit Server VM 11.0.22+7-LTS on Mac OS X 14.6.1
Apple M3 Max
contains:                                 Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Spark                                                10             69          27          0.1        9603.6       1.0X
Comet (Scan)                                         11             81          26          0.1       10928.1       0.9X
Comet (Scan + Exec)                                  44             91          20          0.0       42889.5       0.2X

Describe the potential solution

Review benchmark to make sure it is valid, then try and optimize performance.

Additional context

No response

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions