[
https://issues.apache.org/jira/browse/PHOENIX-961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
wangwenli updated PHOENIX-961:
------------------------------
Description:
scenario: two big table need be join, now , we first get from one table, then
loop each result and get from another table, we find the QueryPlan is not
reused between each execute, and it seems it waste some cpu times.
below is some info can be refered:
32.0% - 12,391 ms - 646 inv. java.sql.PreparedStatement.executeQuery
32.0% - 12,389 ms - 646 inv.
org.apache.phoenix.jdbc.PhoenixPreparedStatement.executeQuery
31.9% - 12,364 ms - 646 inv.
org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.executeQuery
17.9% - 6,920 ms - 646 inv.
org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.optimizePlan
14.0% - 5,424 ms - 646 inv.
org.apache.phoenix.execute.BasicQueryPlan.getScanner
was:scenario: two big table need be join, now , we first get from one table,
then loop each result and get from another table, we find the QueryPlan is not
reused between each execute, and it seems it waste some cpu times.
> QueryPlan can be reused if the sql but parameter is same
> --------------------------------------------------------
>
> Key: PHOENIX-961
> URL: https://issues.apache.org/jira/browse/PHOENIX-961
> Project: Phoenix
> Issue Type: Improvement
> Affects Versions: 2.2.3, 3.0.0, 4.0.0
> Reporter: wangwenli
> Labels: performance
>
> scenario: two big table need be join, now , we first get from one table, then
> loop each result and get from another table, we find the QueryPlan is not
> reused between each execute, and it seems it waste some cpu times.
> below is some info can be refered:
> 32.0% - 12,391 ms - 646 inv. java.sql.PreparedStatement.executeQuery
>
> 32.0% - 12,389 ms - 646 inv.
> org.apache.phoenix.jdbc.PhoenixPreparedStatement.executeQuery
>
> 31.9% - 12,364 ms - 646 inv.
> org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.executeQuery
>
> 17.9% - 6,920 ms - 646 inv.
> org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.optimizePlan
>
> 14.0% - 5,424 ms - 646 inv.
> org.apache.phoenix.execute.BasicQueryPlan.getScanner
--
This message was sent by Atlassian JIRA
(v6.2#6252)
