airborne12 opened a new pull request, #24751: URL: https://github.com/apache/doris/pull/24751
## Proposed changes Issue Number: close #xxx improve performance for match without index, from 2 min 34.54 sec to 9.16s, on httplogs dataset. ``` mysql> select COUNT() from wc_httplogs_without_index where request match "GET"; +-----------+ | count(*) | +-----------+ | 245552656 | +-----------+ 1 row in set (29.29 sec) mysql> select COUNT() from wc_httplogs where request match "GET"; +-----------+ | count(*) | +-----------+ | 245552656 | +-----------+ 1 row in set (0.51 sec) mysql> select COUNT() from wc_httplogs_without_index where request match "GET"; +-----------+ | count(*) | +-----------+ | 245552656 | +-----------+ 1 row in set (2 min 34.54 sec) mysql> select COUNT() from wc_httplogs_without_index where request match "GET"; +-----------+ | count(*) | +-----------+ | 245552656 | +-----------+ 1 row in set (9.16 sec) ``` ## Further comments If this is a relatively large or complex change, kick off the discussion at [[email protected]](mailto:[email protected]) by explaining why you chose the solution you did and what alternatives you considered, etc... -- 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]
