[jira] [Updated] (RANGER-2205) Optimize view 'vx_trx_log' to improve query performance
[ https://issues.apache.org/jira/browse/RANGER-2205?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Peng Xing updated RANGER-2205: -- Attachment: (was: 0001-RANGER-2205-Optimize-view-vx_trx_log-to-improve-quer.patch) > Optimize view 'vx_trx_log' to improve query performance > --- > > Key: RANGER-2205 > URL: https://issues.apache.org/jira/browse/RANGER-2205 > Project: Ranger > Issue Type: Bug > Components: admin >Affects Versions: master >Reporter: Peng Xing >Assignee: Peng Xing >Priority: Major > Attachments: > 0001-RANGER-2205-Optimize-view-vx_trx_log-to-improve-quer.patch > > > When the number of records in the table 'x_trx_log' is 1000, the view > 'vx_trx_log' query takes about 14.651 seconds. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (RANGER-2205) Optimize view 'vx_trx_log' to improve query performance
[ https://issues.apache.org/jira/browse/RANGER-2205?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Peng Xing updated RANGER-2205: -- Attachment: 0001-RANGER-2205-Optimize-view-vx_trx_log-to-improve-quer.patch > Optimize view 'vx_trx_log' to improve query performance > --- > > Key: RANGER-2205 > URL: https://issues.apache.org/jira/browse/RANGER-2205 > Project: Ranger > Issue Type: Bug > Components: admin >Affects Versions: master >Reporter: Peng Xing >Assignee: Peng Xing >Priority: Major > Attachments: > 0001-RANGER-2205-Optimize-view-vx_trx_log-to-improve-quer.patch > > > When the number of records in the table 'x_trx_log' is 1000, the view > 'vx_trx_log' query takes about 14.651 seconds. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (RANGER-2205) Optimize view 'vx_trx_log' to improve query performance
[ https://issues.apache.org/jira/browse/RANGER-2205?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Peng Xing updated RANGER-2205: -- Attachment: 0001-RANGER-2205-Optimize-view-vx_trx_log-to-improve-quer.patch > Optimize view 'vx_trx_log' to improve query performance > --- > > Key: RANGER-2205 > URL: https://issues.apache.org/jira/browse/RANGER-2205 > Project: Ranger > Issue Type: Bug > Components: admin >Affects Versions: master >Reporter: Peng Xing >Assignee: Peng Xing >Priority: Major > Attachments: > 0001-RANGER-2205-Optimize-view-vx_trx_log-to-improve-quer.patch > > > When the number of records in the table 'x_trx_log' is 1000, the view > 'vx_trx_log' query takes about 14.651 seconds. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (RANGER-2205) Optimize view 'vx_trx_log' to improve query performance
[ https://issues.apache.org/jira/browse/RANGER-2205?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Peng Xing updated RANGER-2205: -- Description: When the number of records in the table 'x_trx_log' is 1000, the view 'vx_trx_log' query takes about 14.651 seconds. was: When the number of records in the table 'x_trx_log' is 1000, the view 'vx_trx_log' query takes about 14.651 seconds. Replace 'select in' with 'not exsit', after SQL optimization, the query is about 0.048 second. > Optimize view 'vx_trx_log' to improve query performance > --- > > Key: RANGER-2205 > URL: https://issues.apache.org/jira/browse/RANGER-2205 > Project: Ranger > Issue Type: Bug > Components: admin >Affects Versions: master >Reporter: Peng Xing >Assignee: Peng Xing >Priority: Major > > When the number of records in the table 'x_trx_log' is 1000, the view > 'vx_trx_log' query takes about 14.651 seconds. -- This message was sent by Atlassian JIRA (v7.6.3#76005)