Uploaded image for project: 'Compass '
  1. Compass
  2. COMPASS-5791

Compass collect actual document count when browser collection automatically.

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major - P3 Major - P3
    • None
    • 1.31.2
    • Aggregation pipeline
    • None
    • MacOS Catalina 10.15.7(19H2)
    • 3

    Description

      Problem Statement/Rationale

      Looks Compass collect actual document count when users browser collection.

      Compass run following aggregate query. 

      db.collection.aggregate( [{
          $group: {_id: null, count: { $count: { } } }
      }] );

      But this may scan full collection or index which takes a lot of time for huge collections. Also consume lots of computing resources.

      I think this should not be automatically collected.

      This should be either configurable option(or action button on GUI) or eliminated.

      Steps to Reproduce

      Login some mongodb cluster, click some collection on left bottom of GUI

      Expected Results

      Minimize system resource usage

      Actual Results

      Doing full collection full or full index scan to collection's document count (using aggregate command)

      Additional Notes

      Any additional information that may be useful to include.

      Attachments

        Activity

          People

            Unassigned Unassigned
            sunguck.lee@gmail.com 아나 하리
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated: