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

Compass collect actual document count when browser collection automatically.

    • Type: Icon: Bug Bug
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 1.31.2
    • Component/s: Aggregation pipeline
    • None
    • Environment:
      MacOS Catalina 10.15.7(19H2)
    • 3

      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.

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

              Created:
              Updated: