My collection is called places, it is used by 2 clients, one with 370 documents and the other with 250. On Thursday, both clients were very happy and at 09:00 on Friday, one of them began to wait approximately 1:40 minutes for each query. towards. The other took 10-12 seconds. The queries are made by the ownerId and sharedUser, both compound indexed
Analyze the weight of each document in the client that takes longer and there is no record that weighs more than 5kb, at most there are a couple of them that weigh 100kb, I even deactivated one of 100kb and the problem persisted.
The same thing happened on Tuesday and Wednesday, everything solved… I didn’t understand what happened.
The size of the collection is just:
Storage size: 880.64KB
Avg. document size: 3.35 kB
Total index size: 167.94 kB
It is even much faster to export the entire collection than to do the query.
And to add more inconsistency, this same client consults another collection and it takes too long… very distressing.
Will it be something from the internal cache, oplog of some query?