Uploaded image for project: 'Infinispan'
  1. Infinispan
  2. ISPN-12425

Inifinispan + JDBC cachestore runs statistic collection on Oracle DB

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • None
    • 11.0.4.Final
    • Loaders and Stores
    • None
    • Undefined

    Description

      In class OracleTableManager at string 61 there is:

      rs = meta.getIndexInfo(null, null, tableName.toString(), false, false);

      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.

       

       

      Attachments

        Activity

          People

            remerson@redhat.com Ryan Emerson
            c0ff75 Evgenii Balakhonov (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: