You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@trafodion.apache.org by "Qifan Chen (JIRA)" <ji...@apache.org> on 2015/09/21 17:46:04 UTC

[jira] [Commented] (TRAFODION-1495) Update stats: the decision to not use internal sorting in memory needs some adjustment

    [ https://issues.apache.org/jira/browse/TRAFODION-1495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14900857#comment-14900857 ] 

Qifan Chen commented on TRAFODION-1495:
---------------------------------------

Under 1 second if sorting in memory. 

> Update stats:  the decision to not use internal sorting in memory needs some adjustment
> ---------------------------------------------------------------------------------------
>
>                 Key: TRAFODION-1495
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1495
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-cmp
>            Reporter: Qifan Chen
>
> It is found that the threshold to favor internal sort in memory may be set too high to favor sorting via SQL. In some test case, sorting via SQL on column took 2.5 minutes while the same task can be completed under 1 second. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)