xs-sun commented on issue #8095:
URL:
https://github.com/apache/incubator-seata/issues/8095#issuecomment-4411892733
我这边使用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:<init>() #74
+---[99.72% 17.85525ms ]
org.apache.seata.sqlparser.druid.oceanbase.OceanBaseInsertRecognizer$1:<init>()
#75
+---[0.02% 0.00334ms ]
com.alibaba.druid.sql.ast.statement.SQLInsertStatement:getTableSource() #83
+---[0.03% 0.00561ms ]
com.alibaba.druid.sql.dialect.oracle.visitor.OracleOutputVisitor:visit() #83
`---[0.01% 0.00181ms ] java.lang.StringBuilder:toString() #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:<init>() #156
+---[99.69% 18.169972ms ]
org.apache.seata.sqlparser.druid.oceanbase.OceanBaseUpdateRecognizer$1:<init>()
#157
+---[0.02% 0.00338ms ]
com.alibaba.druid.sql.ast.statement.SQLUpdateStatement:getTableSource() #170
+---[0.05% 0.009331ms ]
com.alibaba.druid.sql.dialect.oracle.visitor.OracleOutputVisitor:visit() #172
`---[0.01% 0.00155ms ] java.lang.StringBuilder:toString() #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:<init>() #156
+---[99.70% 17.88639ms ]
org.apache.seata.sqlparser.druid.oceanbase.OceanBaseUpdateRecognizer$1:<init>()
#157
+---[0.02% 0.00323ms ]
com.alibaba.druid.sql.ast.statement.SQLUpdateStatement:getTableSource() #170
+---[0.04% 0.00768ms ]
com.alibaba.druid.sql.dialect.oracle.visitor.OracleOutputVisitor:visit() #172
`---[0.01% 0.00161ms ] java.lang.StringBuilder:toString() #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:<init>() #74
+---[99.12% 4.8062ms ]
org.apache.seata.sqlparser.druid.oceanbase.OceanBaseInsertRecognizer$1:<init>()
#75
+---[0.06% 0.00281ms ]
com.alibaba.druid.sql.ast.statement.SQLInsertStatement:getTableSource() #83
+---[0.09% 0.00455ms ]
com.alibaba.druid.sql.dialect.oracle.visitor.OracleOutputVisitor:visit() #83
`---[0.03% 0.00168ms ] java.lang.StringBuilder:toString() #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:<init>() #74
+---[98.90% 4.555958ms ]
org.apache.seata.sqlparser.druid.oceanbase.OceanBaseInsertRecognizer$1:<init>()
#75
+---[0.21% 0.00976ms ]
com.alibaba.druid.sql.ast.statement.SQLInsertStatement:getTableSource() #83
+---[0.11% 0.00493ms ]
com.alibaba.druid.sql.dialect.oracle.visitor.OracleOutputVisitor:visit() #83
`---[0.04% 0.00194ms ] java.lang.StringBuilder:toString() #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:<init>() #156
+---[98.92% 4.878581ms ]
org.apache.seata.sqlparser.druid.oceanbase.OceanBaseUpdateRecognizer$1:<init>()
#157
+---[0.06% 0.00283ms ]
com.alibaba.druid.sql.ast.statement.SQLUpdateStatement:getTableSource() #170
+---[0.16% 0.00781ms ]
com.alibaba.druid.sql.dialect.oracle.visitor.OracleOutputVisitor:visit() #172
`---[0.03% 0.00157ms ] java.lang.StringBuilder:toString() #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]
