[
https://issues.apache.org/jira/browse/IGNITE-21080?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yury Gerzhedovich updated IGNITE-21080:
---------------------------------------
Issue Type: Improvement (was: Bug)
> Improve of calculation cache sizes for SQL engine
> -------------------------------------------------
>
> Key: IGNITE-21080
> URL: https://issues.apache.org/jira/browse/IGNITE-21080
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Yury Gerzhedovich
> Priority: Major
> Labels: ignite-3
>
> As of now we use hardcoded constants for our internal caches, it looks wrong.
> These constants for first glance shouldn't be configured by user, but we
> could use calculated estimated size.
> Let't make the improvement:
> ||Constant||Proposed calculation||
> |SqlQueryProcessor#PARSED_RESULT_CACHE_SIZE
> |SqlQueryProcessor#PLAN_CACHE_SIZE *3|
> |ExecutionServiceImpl#CACHE_SIZE|SqlQueryProcessor#PLAN_CACHE_SIZE * 3|
> |SqlQueryProcessor#TABLE_CACHE_SIZE|number of tables * 2|
> |SqlQueryProcessor#SCHEMA_CACHE_SIZE|as of now used for two caches, need to
> use TABLE_CACHE_SIZE for table cache, and keep as is for catalog versions.|
> | | |
> We could introduce recreate caches for significant change amount of tables in
> a cluster.
> -
> -
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
