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

Queries Taking more then expected time for small collection

    XMLWordPrintableJSON

Details

    • Icon: Question Question
    • Resolution: Works as Designed
    • Icon: Major - P3 Major - P3
    • None
    • 3.4.23
    • None
    • None
    • Fully Compatible

    Description

      We have a collection on production environment and it is having only 126 records, but it is taking maximum 6 seconds for a single findOne operation. 

      We are using mongodb version 3.4 , and it is having very slow response time for even smaller find operations. All the find operations are using IXSCAN with proper index utilisation, and all read and write operations are taking more than 1 second even with smaller document size having 10-12 fields.

      We have 37GB of data and our production environment having 3 member replica set with primary, secondary, secondary configuration.

      Please update us with possible optimisation methods.

      Attachments

        Activity

          People

            dmitry.agranat@mongodb.com Dmitry Agranat
            pratiksha.gupta38@gmail.com Pratiksha Aggarwal
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: