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

    • Improvement
    • Status: Closed
    • Major - P3
    • Resolution: Done
    • 4.2.0
    • None
    • Performance
    • None
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: