Improve fetching data performance when cmt use online database mode of the source database

Details

Description

CUBRID should use paging query when it run a query with a large scale table.
So, it can be increasingly slow during exporting data.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Isaiah Choe added a comment -

CUBRID의 경우에만 있는 range scan을 PK를 이용하도록 하여 paging 탐색 시간을 줄였습니다.

Show
Isaiah Choe added a comment - CUBRID의 경우에만 있는 range scan을 PK를 이용하도록 하여 paging 탐색 시간을 줄였습니다.
Hide
Permalink
董志玲(Ella) added a comment -

Compare with build 8.4.3.4001.
When migrate 100,000 records,each record has about 200 char and 5 int data.Migtrate from CUBRID 8.4.1 to CUBRID 8.4.3.
CMT8.4.3.4001 used about 11min:20s,CMT8.4.3 used about 46s.
Performance improved many much.

Show
董志玲(Ella) added a comment - Compare with build 8.4.3.4001. When migrate 100,000 records,each record has about 200 char and 5 int data.Migtrate from CUBRID 8.4.1 to CUBRID 8.4.3. CMT8.4.3.4001 used about 11min:20s,CMT8.4.3 used about 46s. Performance improved many much.
Hide
Permalink
董志玲(Ella) added a comment -

Compared 8.4.3.4001 with 8.4.3.4034.

Show
董志玲(Ella) added a comment - Compared 8.4.3.4001 with 8.4.3.4034.

People

  • Assignee:
    Isaiah Choe
    Reporter:
    Isaiah Choe
Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: