I have a document with 3 million records, I created view and I want to filter data by some fields (e.g. between date or some other conditions), how I can do this?
If I use GetView("view", "view").Where(o => ...) it's returns all data from view and it's terrible for perfomance.
You cannot use 2 keys to filter in a view. The map function generates only 1 single key on which you can apply filter.
Based on your data model and views you may use Compound keys/criterion as documented here
Let me know if this is ok with your use case
Yeh, I know.
I meant 1 compound key and yes - it's that I need.