Performance slows on MongoDB SRP site

Slow performance on MongoDB SRP site

The getCount calls used by pages loading comments are very slow due to missing compound index.

Resolution

  1. Log in to Mongo shell or another mongo shell tool such as RoboMongo.

  2. Access the SRP database, for example, the shell command use: 

    use aem-msrp

  3. Run this MongoDB shell command against the database to create an index in the background: 

    db.content.createIndex({ parent_id_s: 1, base_type_s : 1 }, { background: true })

Poznámka:

Make sure to run the command during low traffic hours as this creates the index while the system is in use.  For more details on background index creation, see MongoDB docs.

 Adobe

Získajte pomoc rýchlejšie a ľahšie

Nový užívateľ?

Adobe MAX 2024

Adobe MAX
Konferencia o kreativite

14. – 16. októbra Miami Beach a online

Adobe MAX

Konferencia o kreativite

14. – 16. októbra Miami Beach a online

Adobe MAX 2024

Adobe MAX
Konferencia o kreativite

14. – 16. októbra Miami Beach a online

Adobe MAX

Konferencia o kreativite

14. – 16. októbra Miami Beach a online