FindDocumentByDocID vs FindDocumentByKeyValue Followup

0 votes
This question is a follow up to answered question (  

Obviously, lookups by DocID will be significantly faster then by Key/Value pair, but can you go into more detail about how big of a performance difference there is? For instance, if I have a collection of one million json files, how long would it take for each query (by DocID and By Key/Value) to run? I am trying to identify the scope of the performance loss that could be incurred by using a Key/Value lookup.
asked Jun 15, 2015 in App42 Cloud API-BaaS by judahbloom (15 points)

1 Answer

0 votes
Best answer


As we already describe that FindDocumentById would be faster than key/value method as it has direct reference of doc in the database and would give you the fastest result. Response of key/value method would be slower however non trivial to your app performance. In addition to the above thing, it will not make any big impact on your app performance. Your query will only take few miliseconds to complete your search in million of documents. 

Let us know if it helps.


Himanshu Sharma

answered Jun 15, 2015 by hs00105 (2,005 points)
selected Jun 18, 2015 by judahbloom
Download Widgets
Welcome to ShepHertz Product line forum, where you can ask questions and receive answers from the community. You can also reach out to us on