songenjie commented on pull request #4284: URL: https://github.com/apache/incubator-doris/pull/4284#issuecomment-680461074
> @songenjie Hi, what's your design doc for this PR? I think this PR is repeated with SQL mode cache in #4330 , what do you think it？ @kangkaisen 1. Sql Cache Mode - If this switch is turned on, the SQL query result set will be cached. If the interval between the last visit version time in all partitions of all tables in the query is greater than cache_last_version_interval_second, and the result set is less than cache_result_max_row_count, the result set will be cached, and the next same SQL will hit the cache. 2. this PR `Result Cache` - Solve the same connect ID, the same SQL high QPS problem, the same user, in `result_ cache_ expire_ after_ In_ Within milliseconds` time, executing the same SQL will hit the result cache ---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
