CODEWITHSUNDEEP
ravendb
Igorek
Igorek

Reputation: 15850

RavenDb - What's faster?

I need to do a query in RavenDb and perform a get on a document by Id and a secondary parameter.

To be more precise, I'd like to load a document by document Id and by ApiKey. If the ApiKey of the given document does not match I want a null back.

My question is, is it faster to do a Query with Id and ApiKey comparison, or is it faster to do a Load by Id and throw away the document in code if the ApiKey does not match. My documents are probably 20k in size.

Upvotes: 2

Views: 59

Answers (1)

Ayende Rahien
Ayende Rahien

Reputation: 22956

Do a load by id, then compare.

Upvotes: 3

Related Questions