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

The current SQL query that checks table existence is under optimized on big database

    XMLWordPrintable

Details

    Description

      Last year I proposed an enhancement allowing to use the implicit db schema to ease life of end-user, unfortunately it seems that it affects the startup time of the product when the tables contain a lot of rows. Indeed the query can take several seconds to return a result.

      The idea of this task would be to optimize this query for all supported databases in order to avoid this drawback.

      Attachments

        Issue Links

          is related to

          Enhancement - An enhancement or refactoring of existing functionality ISPN-1204 Make JDBC cache store use implicit schemas for database tables

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed
          relates to

          Feature Request - Feature requests from customers and/or users ISPN-4229 The JDBC Cache store should not require the schema name configuration

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • To Do

          Activity

            People

              ttarrant@redhat.com Tristan Tarrant
              nfilotto Nicolas Filotto (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: