Uploaded image for project: '[Read Only] - Hippo Repository'
  1. [Read Only] - Hippo Repository
  2. REPO-588

Support fast date range query support on dates out of the box

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed
    • Normal
    • Resolution: Fixed
    • None
    • 2.24.02
    • 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

          Activity

            People

              svoortman Simon Voortman (Inactive)
              aschrijvers Ard Schrijvers
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: