Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-46874

Create view becomes very slow when system has many (10000+) views

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Done
    • Affects Version/s: 4.2.0
    • Fix Version/s: None
    • Component/s: Performance
    • Labels:
      None
    • Backwards Compatibility:
      Fully Compatible

      Description

      Mongo Server reloads the view catalog when view created / updated / dropped. We have tens of thousands of views in database, and it's getting more and more slower to create or modify view.

      Is it possible to make the view reload optional? 

        Attachments

        1. collMode_createIndex.png
          collMode_createIndex.png
          189 kB
        2. collMode.png
          collMode.png
          163 kB

          Issue Links

          depends on

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-46865 collMod should not take database MODE_X lock

          • Major - P3 - Major loss of function.
          • Closed

            Activity

              People

              Assignee:
              dmitry.agranat Dmitry Agranat
              Reporter:
              xiaoqiang.chou@gmail.com Xiaoqiang Zhou
              Participants:
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: