[
https://issues.apache.org/jira/browse/TRAFODION-3106?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
He Zhenxing updated TRAFODION-3106:
-----------------------------------
Description:
create/drop table is slow, usually takes seconds to finish, this problem is
specially severe for tables with blob columns, which will slow down linearly
with the number of blob columns (cqd traf_blob_as_varchar 'off'), which would
make it unusable in case tables need to be created and dropped frequently.
For each blob column, two associated tables will be create, so the time for
creating tables with blob columns will increase linearly. In a local testing
environment, creating a table with 5 blob columns takes 75 seconds, drop the
table without any data takes more than 90 seconds.
For create table, about half of the time are consumed by calls to
createHbaseTable(), and another 30% are consumed by calls to
getSeabaseUserTableDesc(), for drop table, most of the time are spend on the
calls to getSeabaseUserTableDesc() and ENDTRANSACTION_ERR().
was:
create/drop table is slow, usually takes seconds to finish, this problem is
specially severe for tables with blob columns, which will slow down linearly
with the number of blob columns (cqd traf_blob_as_varchar 'off'), which would
make it unusable in case tables need to be created and dropped frequently.
For each blob column, two associated tables will be create, so the time for
creating tables with blob columns will increase linearly. In a local testing
environment, creating a table with 5 blob columns takes 75 seconds, drop the
table without any data takes more than 90 seconds.
> create/drop table painfully slow with blob columns
> --------------------------------------------------
>
> Key: TRAFODION-3106
> URL: https://issues.apache.org/jira/browse/TRAFODION-3106
> Project: Apache Trafodion
> Issue Type: Improvement
> Components: sql-exe
> Affects Versions: 2.4
> Environment: CentOS 6.9
> Reporter: He Zhenxing
> Priority: Major
>
> create/drop table is slow, usually takes seconds to finish, this problem is
> specially severe for tables with blob columns, which will slow down linearly
> with the number of blob columns (cqd traf_blob_as_varchar 'off'), which would
> make it unusable in case tables need to be created and dropped frequently.
> For each blob column, two associated tables will be create, so the time for
> creating tables with blob columns will increase linearly. In a local testing
> environment, creating a table with 5 blob columns takes 75 seconds, drop the
> table without any data takes more than 90 seconds.
> For create table, about half of the time are consumed by calls to
> createHbaseTable(), and another 30% are consumed by calls to
> getSeabaseUserTableDesc(), for drop table, most of the time are spend on the
> calls to getSeabaseUserTableDesc() and ENDTRANSACTION_ERR().
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
