You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ranger.apache.org by Pradeep Agrawal <pr...@gmail.com> on 2019/05/06 05:00:55 UTC
Re: Review Request 68667: RANGER-2205 Optimize view 'vx_trx_log' to
improve query performance
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/68667/#review215041
-----------------------------------------------------------
Can you update this patch and make the db patch number to 042 rather 035.
- Pradeep Agrawal
On Sept. 7, 2018, 6:53 a.m., Xing Peng wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/68667/
> -----------------------------------------------------------
>
> (Updated Sept. 7, 2018, 6:53 a.m.)
>
>
> Review request for ranger.
>
>
> Bugs: RANGER-2205
> https://issues.apache.org/jira/browse/RANGER-2205
>
>
> Repository: ranger
>
>
> 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.
>
>
> Diffs
> -----
>
> security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql 3f23b0082
> security-admin/db/mysql/patches/035-update-view-vx_trx_log-and-add-index-on-table-x_trx_log.sql PRE-CREATION
> security-admin/db/oracle/optimized/current/ranger_core_db_oracle.sql bafdb9676
> security-admin/db/oracle/patches/035-update-view-vx_trx_log-and-add-index-on-table-x_trx_log.sql PRE-CREATION
> security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql 2bc58acfe
> security-admin/db/postgres/patches/035-update-view-vx_trx_log-and-add-index-on-table-x_trx_log.sql PRE-CREATION
> security-admin/db/sqlanywhere/optimized/current/ranger_core_db_sqlanywhere.sql 1b64eeac8
> security-admin/db/sqlanywhere/patches/035-update-view-vx_trx_log-and-add-index-on-table-x_trx_log.sql PRE-CREATION
> security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql 4a216fed9
> security-admin/db/sqlserver/patches/035-update-view-vx_trx_log-and-add-index-on-table-x_trx_log.sql PRE-CREATION
>
>
> Diff: https://reviews.apache.org/r/68667/diff/2/
>
>
> Testing
> -------
>
>
> Thanks,
>
> Xing Peng
>
>