[GitHub] [incubator-doris] songenjie commented on pull request #4284: [Apache][Doris][Feature][FE]Support users with high QPS in the same query through result set cache

[GitBox <gi...@apache.org>]

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:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org