You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/10/10 06:42:41 UTC
[GitHub] [shardingsphere] gzgzapp opened a new issue, #12691: oracle getIndexInfo is slow
gzgzapp opened a new issue, #12691:
URL: https://github.com/apache/shardingsphere/issues/12691
### Which version of ShardingSphere did you use?
5.0.0-alpha
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
### Expected behavior
Start my app as soon as possible
### Actual behavior
Load meta data for schema logic_db finished, cost 127788 milliseconds.
### Reason analyze (If you can)
the method getIndexInfo() in jdbc has 5 param，the 5th param approximate, when true, result is allowed to reflect approximate or out of data values; when false, results are requested to be accurate，in the oracle jdbc implment, if approximate is false, it will analyze table compute statistics, the table records over 10 million，table compute statistics cost too much time, DBAs have their own plans to analyze table compute statistics, so, the param approximate can configure in the rule configuration file?
public static Collection<PhysicalIndexMetaData> load(final Connection connection, final String table) throws SQLException {
Collection<PhysicalIndexMetaData> result = new HashSet<>();
try (ResultSet resultSet = connection.getMetaData().getIndexInfo(connection.getCatalog(), connection.getSchema(), table, false, false)) {
while (resultSet.next()) {
String indexName = resultSet.getString(INDEX_NAME);
if (null != indexName) {
result.add(new PhysicalIndexMetaData(indexName));
}
}
}
return result;
}
--
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: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu commented on issue #12691: oracle getIndexInfo is slow
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #12691:
URL: https://github.com/apache/shardingsphere/issues/12691#issuecomment-1179498628
Oracle is not the trunk feature for now, I just set the issue as good amateur issue
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] commented on issue #12691: oracle getIndexInfo is slow
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #12691:
URL: https://github.com/apache/shardingsphere/issues/12691#issuecomment-1272350730
Hello , this issue has not received a reply for several days.
This issue is supposed to be closed.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] oracle getIndexInfo is slow [shardingsphere]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #12691:
URL: https://github.com/apache/shardingsphere/issues/12691#issuecomment-2026022748
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] closed issue #12691: oracle getIndexInfo is slow
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #12691: oracle getIndexInfo is slow
URL: https://github.com/apache/shardingsphere/issues/12691
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org