xs-sun commented on issue #8095: URL: https://github.com/apache/incubator-seata/issues/8095#issuecomment-4416883814
> How can you prove that fetching the tableName is as time-consuming as you suggested? tableMeta itself is just a few map.get operations, so what performance issue would there be at this point? ``` 这边使用arthas 跟踪发现getTableName 最长竟然需要18ms。 ---ts=2026-05-08 19:29:40;thread_name=ConsumeMessageThread_test_CONSUMER_GROUP_PROCESS_RECEIVE_7;id=5993;is_daemon=false;priority=5;TCCL=org.springframework.boot.loader.LaunchedURLClassLoader@21b8d17c ---[17.90492ms] org.apache.seata.sqlparser.druid.oceanbase.OceanBaseInsertRecognizer:getTableName() +---[0.01% 0.00156ms ] java.lang.StringBuilder:() https://github.com/apache/incubator-seata/issues/74 +---[99.72% 17.85525ms ] org.apache.seata.sqlparser.druid.oceanbase.OceanBaseInsertRecognizer$1:() https://github.com/apache/incubator-seata/issues/75 +---[0.02% 0.00334ms ] com.alibaba.druid.sql.ast.statement.SQLInsertStatement:getTableSource() https://github.com/apache/incubator-seata/pull/83 +---[0.03% 0.00561ms ] com.alibaba.druid.sql.dialect.oracle.visitor.OracleOutputVisitor:visit() https://github.com/apache/incubator-seata/pull/83 `---[0.01% 0.00181ms ] java.lang.StringBuilder:toString() https://github.com/apache/incubator-seata/issues/84 ---ts=2026-05-08 19:29:40;thread_name=ForkJoinPool.commonPool-worker-25;id=661;is_daemon=true;priority=5;TCCL=org.springframework.boot.loader.LaunchedURLClassLoader@21b8d17c ---[18.227223ms] org.apache.seata.sqlparser.druid.oceanbase.OceanBaseUpdateRecognizer:getTableName() +---[0.01% 0.00188ms ] java.lang.StringBuilder:() https://github.com/apache/incubator-seata/pull/156 +---[99.69% 18.169972ms ] org.apache.seata.sqlparser.druid.oceanbase.OceanBaseUpdateRecognizer$1:() https://github.com/apache/incubator-seata/pull/157 +---[0.02% 0.00338ms ] com.alibaba.druid.sql.ast.statement.SQLUpdateStatement:getTableSource() https://github.com/apache/incubator-seata/issues/170 +---[0.05% 0.009331ms ] com.alibaba.druid.sql.dialect.oracle.visitor.OracleOutputVisitor:visit() https://github.com/apache/incubator-seata/issues/172 `---[0.01% 0.00155ms ] java.lang.StringBuilder:toString() https://github.com/apache/incubator-seata/pull/178 ---ts=2026-05-08 19:29:40;thread_name=ForkJoinPool.commonPool-worker-11;id=1005;is_daemon=true;priority=5;TCCL=org.springframework.boot.loader.LaunchedURLClassLoader@21b8d17c ---[17.93945ms] org.apache.seata.sqlparser.druid.oceanbase.OceanBaseUpdateRecognizer:getTableName() +---[0.01% 0.0017ms ] java.lang.StringBuilder:() https://github.com/apache/incubator-seata/pull/156 +---[99.70% 17.88639ms ] org.apache.seata.sqlparser.druid.oceanbase.OceanBaseUpdateRecognizer$1:() https://github.com/apache/incubator-seata/pull/157 +---[0.02% 0.00323ms ] com.alibaba.druid.sql.ast.statement.SQLUpdateStatement:getTableSource() https://github.com/apache/incubator-seata/issues/170 +---[0.04% 0.00768ms ] com.alibaba.druid.sql.dialect.oracle.visitor.OracleOutputVisitor:visit() https://github.com/apache/incubator-seata/issues/172 `---[0.01% 0.00161ms ] java.lang.StringBuilder:toString() https://github.com/apache/incubator-seata/pull/178 ---ts=2026-05-08 19:29:40;thread_name=ConsumeMessageThread_test_CONSUMER_GROUP_PROCESS_RECEIVE_7;id=5993;is_daemon=false;priority=5;TCCL=org.springframework.boot.loader.LaunchedURLClassLoader@21b8d17c ---[4.848981ms] org.apache.seata.sqlparser.druid.oceanbase.OceanBaseInsertRecognizer:getTableName() +---[0.03% 0.0015ms ] java.lang.StringBuilder:() https://github.com/apache/incubator-seata/issues/74 +---[99.12% 4.8062ms ] org.apache.seata.sqlparser.druid.oceanbase.OceanBaseInsertRecognizer$1:() https://github.com/apache/incubator-seata/issues/75 +---[0.06% 0.00281ms ] com.alibaba.druid.sql.ast.statement.SQLInsertStatement:getTableSource() https://github.com/apache/incubator-seata/pull/83 +---[0.09% 0.00455ms ] com.alibaba.druid.sql.dialect.oracle.visitor.OracleOutputVisitor:visit() https://github.com/apache/incubator-seata/pull/83 `---[0.03% 0.00168ms ] java.lang.StringBuilder:toString() https://github.com/apache/incubator-seata/issues/84 ---ts=2026-05-08 19:29:40;thread_name=ConsumeMessageThread_test_CONSUMER_GROUP_PROCESS_RECEIVE_7;id=5993;is_daemon=false;priority=5;TCCL=org.springframework.boot.loader.LaunchedURLClassLoader@21b8d17c ---[4.606558ms] org.apache.seata.sqlparser.druid.oceanbase.OceanBaseInsertRecognizer:getTableName() +---[0.03% 0.00158ms ] java.lang.StringBuilder:() https://github.com/apache/incubator-seata/issues/74 +---[98.90% 4.555958ms ] org.apache.seata.sqlparser.druid.oceanbase.OceanBaseInsertRecognizer$1:() https://github.com/apache/incubator-seata/issues/75 +---[0.21% 0.00976ms ] com.alibaba.druid.sql.ast.statement.SQLInsertStatement:getTableSource() https://github.com/apache/incubator-seata/pull/83 +---[0.11% 0.00493ms ] com.alibaba.druid.sql.dialect.oracle.visitor.OracleOutputVisitor:visit() https://github.com/apache/incubator-seata/pull/83 `---[0.04% 0.00194ms ] java.lang.StringBuilder:toString() https://github.com/apache/incubator-seata/issues/84 ---ts=2026-05-08 19:29:40;thread_name=ForkJoinPool.commonPool-worker-11;id=1005;is_daemon=true;priority=5;TCCL=org.springframework.boot.loader.LaunchedURLClassLoader@21b8d17c ---[4.931891ms] org.apache.seata.sqlparser.druid.oceanbase.OceanBaseUpdateRecognizer:getTableName() +---[0.04% 0.00184ms ] java.lang.StringBuilder:() https://github.com/apache/incubator-seata/pull/156 +---[98.92% 4.878581ms ] org.apache.seata.sqlparser.druid.oceanbase.OceanBaseUpdateRecognizer$1:() https://github.com/apache/incubator-seata/pull/157 +---[0.06% 0.00283ms ] com.alibaba.druid.sql.ast.statement.SQLUpdateStatement:getTableSource() https://github.com/apache/incubator-seata/issues/170 +---[0.16% 0.00781ms ] com.alibaba.druid.sql.dialect.oracle.visitor.OracleOutputVisitor:visit() https://github.com/apache/incubator-seata/issues/172 `---[0.03% 0.00157ms ] java.lang.StringBuilder:toString() https://github.com/apache/incubator-seata/pull/178 ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
