[
https://issues.apache.org/jira/browse/TRAFODION-1?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Qifan Chen closed TRAFODION-1.
------------------------------
> The number of Scan level ESP processes is too restrictive
> ---------------------------------------------------------
>
> Key: TRAFODION-1
> URL: https://issues.apache.org/jira/browse/TRAFODION-1
> Project: Apache Trafodion
> Issue Type: Improvement
> Environment: spinel testing environment.
> Reporter: Qifan Chen
> Labels: performance
> Original Estimate: 24h
> Remaining Estimate: 24h
>
> The # of scan ESPs is capped at by the total number of ESPs allowed (P).
> Usually P is the CQD "MAX_ESPS_PER_CPU_PER_OP" multiplied by the total number
> of nodes in the cluster.
> To get better scan performance, it is better to allocate the same number of
> ESPs as the number of partitions of a table, which can be larger than P.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)