He Zhenxing created TRAFODION-3265:
--------------------------------------
Summary: INSERT values to VARCHAR column of UTF8 charset can be
extremely slow
Key: TRAFODION-3265
URL: https://issues.apache.org/jira/browse/TRAFODION-3265
Project: Apache Trafodion
Issue Type: Bug
Components: sql-exe
Affects Versions: any
Reporter: He Zhenxing
Fix For: 2.4
When inserting values to varchar column of UTF8 character set, and the values
are a mixture of alphabet and Chinese (or other none-ISO8859-1 characters), the
performance will degrade exponentially according to the number of alphabet
characters.
CREATE TABLE t1 (a VARCHAR(65535) CHARACTER SET UTF8);
INSERT INTO t1 VALUES ('aaa...中文');
Here is a simple test result with different number of 'a's in the insert value:
100 'a's 10 ms
1k 'a's 100 ms
10k 'a's 10 seconds
60k 'a's 160 seconds
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
