Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-3106

create/drop table painfully slow with blob columns

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.4
    • Fix Version/s: None
    • Component/s: sql-exe
    • Labels:
      None
    • Environment:
      CentOS 6.9

      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().

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              hezhenxing He Zhenxing
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: