FQL performance (shell)

I have one collection names “sites”. It contains two documents.
I’m reading it from shell with:
Get(Ref(Collection("sites"), "277193561054642695"))

The read times are too high and inconsistent. (Please find the attached screenshots)

  1. Can you explain why the query time is so high?
  2. Will the query time increase if there are, say, 10,000 documents?
  3. Will the query time increase/decrease if those documents are frequently accessed?

Screenshot 2020-09-20 at 8.01.19 PM

Screenshot 2020-09-20 at 8.01.29 PM

Screenshot 2020-09-20 at 8.01.38 PM

Screenshot 2020-09-20 at 8.01.50 PM

Screenshot 2020-09-20 at 8.01.59 PM

Screenshot 2020-09-20 at 9.15.12 PM

Screenshot 2020-09-20 at 9.15.33 PM

Screenshot 2020-09-20 at 9.15.39 PM

@skris The latencies over the weekend were little high due to an identified issue and we are working hard to prevent them from happening in future.

size of collection does not impact Get latencies as Get works on specific reference and does not even use an Index.

We do not cache documents, so frequency of access does not impact.

Thank you @Jay-Fauna :slightly_smiling_face: