Evgenii Balakhonov created ISPN-12425:
-----------------------------------------
Summary: Inifinispan + JDBC cachestore runs statistic collection on Oracle
DB
Key: ISPN-12425
URL:
https://issues.redhat.com/browse/ISPN-12425
Project: Infinispan
Issue Type: Bug
Components: Loaders and Stores
Affects Versions: 11.0.4.Final
Reporter: Evgenii Balakhonov
In class OracleTableManager at string 61 there is:
rs = meta.getIndexInfo(null, null, tableName.toString(), false,
{color:#FF0000}*false*{color});
last parameter is *approximate* (when true, result is allowed to reflect approximate or
out of data values; when false, results are requested to be accurate)
When Oracle DB used for JDBC cachestore and this parameter == false, then during startup
Infinispan runs statistic gathering for every cache table. As a result it spends a lot of
time during startup.
I think that parameter "approximate" must be changed to true:
rs = meta.getIndexInfo(null, null, tableName.toString(), false, *true*);
in this case Oracle uses existing metainformation of the table.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)