Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: INFORMATION_SCHEMA.COLUMNS表优化
|
username: CHENGX
Requirement Feedback
Please clearly and accurately describe the problem scenario, required behavior, and background information to facilitate timely follow-up by the product team.
[Problem Scenario Involved in the Requirement]
After upgrading from version 6.5 to version 7.5.1, we found that the query performance of the INFORMATION_SCHEMA.COLUMNS table dropped sharply, affecting business operations. Usage: obtaining table structure information through JDBC
DatabaseMetaData metaData = conn.getMetaData();
tableFieldResultSet = metaData.getColumns(catalog, schema, tableName, “%”);
[Expected Requirement Behavior]
Optimize the query for INFORMATION_SCHEMA.COLUMNS. The usage is as follows:
DatabaseMetaData metaData = conn.getMetaData();
tableFieldResultSet = metaData.getColumns(catalog, schema, tableName, “%”);
[Alternative Solutions]
[Background Information]
For example, which users will benefit from this, and some usage scenarios. Any API design, model, or diagram would be helpful.