Details
-
New Feature
-
Status: Closed
-
Normal
-
Resolution: Fixed
-
None
-
None
-
None
Description
Currently, if you have many documents with a unique date (like lastmodificationdate). Range queries on these date properties blow up and get very cpu intensive and memory consuming.
The way developers now work around this is by using a derived propery that rounds the date to, say, DAY granularity. Using a derived data function and an extra property for this is not needed. We can leverage this out of the box in the repository.
We will provide some utilities that help developers to do range queries very easily on the granularity they want. Note that the original properties stay intact, so nothing changes compared to that. Also ordering by the original property often still makes sense.
Attachments
Issue Links
- relates to
-
REPO-590 Backport to 2.22.xx Support fast date range query support on dates out of the box
- Closed
-
HSTTWO-2450 Add out of the box simple API query Filter support for fast range queries on dates
- Closed