[
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.
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.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
