Uploaded image for project: 'Node.js Driver'
  1. Node.js Driver
  2. NODE-1433

Slow Find & Aggregate performance on cold start with a lot of changeStream watches (68)

    • Type: Icon: Bug Bug
    • Resolution: Works as Designed
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Environment:
      Windows 10, Mongo (3.6.4), NodeJS Driver (3.0.7), Node (8.9.4)

      I am having an issue with slow performance now that our system is watching collections for changes (68 collections are being watched).

      I noticed this issue: https://jira.mongodb.org/browse/SERVER-32946

      I increased the poolSize to 100 to actually get the application to work.

      However the first batch of user queries are extremely slow about 11 seconds each. After a few client calls from our web app the server starts performing normally.

      The number of connections (in log) grows to about 80 and it seems to stabilize.

      Any ideas on how I can ideally fix this initial lag or better diagnose what is going on? It seems as if internal connections inside the pool are slow.

      The web app uses a single shared db variable, there is also an express passport middle-ware
      involved using a mongostore.

      TIA
      Kevin

            Assignee:
            Unassigned Unassigned
            Reporter:
            KevinFairclough Kevin Fairclough
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: