Skip to content
Snippets Groups Projects
  1. Feb 02, 2021
  2. Jan 26, 2021
  3. Jan 19, 2021
    • Steven Murray's avatar
      Revert "[catalogue] cta/CTA#951 Fixed" · ecb15fd4
      Steven Murray authored
      This reverts commit 9ba6951d.
      
      The orginal commit is being reverted because it intentionally
      forced the "list contents of a tape" query to use indicies by
      replacing table joins with sub-queries.  These sub-queuries
      unfortunately turned out to be slower than the original query
      when it was executed in a "clean" environment and the database
      live memory cache was cold.  By "clean" environment I mean one
      without PARALLEL enabled on the following two tables:
      
      ARCHIVE_FILE
      TAPE_FILE
      
      PARALLEL is enabled on these two tables when a CASTOR to CTA
      migration takes place.  It was left in place with the hope that
      it would not interferre with the day to day running of CTA.  This
      has now been proven to not be the case.
      ecb15fd4
  4. Jan 15, 2021
  5. Jan 14, 2021
Loading