You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2020/12/30 15:14:46 UTC
[GitHub] [incubator-doris] zhaojintaozhao opened a new issue #5177: Add cache system to enhance query speed
zhaojintaozhao opened a new issue #5177:
URL: https://github.com/apache/incubator-doris/issues/5177
In Big Data analytics systems, there may be many repeated query sqls. Doris generates a query plan for each sql，and call BE and return the query result。These repeated query sqls costs many resources,but return same results.
Therefore, Doris can add a cache system to save the query SQL and the result of the SQL statement. If analytics system call the same query next time , the query result is directly returned from the cache to avoid excessive doris query consumption.
After a database is deleted, a table is deleted, the table schema is changed, or loaded new data to a table, the corresponding query cache becomes invalid.
This feature greatly enhance the query speed in scenarios where there are may repeated queries.
----------------------------------------------------------------
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
[GitHub] [incubator-doris] francisoliverlee commented on issue #5177: Add cache system to enhance query speed
Posted by GitBox <gi...@apache.org>.
francisoliverlee commented on issue #5177:
URL: https://github.com/apache/incubator-doris/issues/5177#issuecomment-753727669
@zhaojintaozhao the lastest version has some cache strategies. doc: [cache doc](http://doris.apache.org/master/zh-CN/administrator-guide/config/fe_config.html#%E9%85%8D%E7%BD%AE%E9%A1%B9%E5%88%97%E8%A1%A8).
----------------------------------------------------------------
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