Uploaded image for project: 'GeoTools'
  1. GeoTools
  2. GEOT-5526

SQL Encoding of Filters on Nested Attributes

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 15.3, 16.0, 17-beta
    • Component/s: app-schema plugin
    • Labels:
      None

      Description

      Currently, filters operating on nested attributes (i.e. attributes of features that are joined to the queried type via feature chaining) are evaluated in memory, after all available features have been loaded.

      Translating these filters to SQL and thus doing the filtering directly in the database backend could bring significant performance improvements, especially when the total number of features in the database is high, but only a few of them would satisfy the filter.

      Related mailing list discussion:
      http://osgeo-org.1560.x6.nabble.com/App-Schema-Encoding-of-Filters-on-Nested-Attributes-td5285165.html

        Attachments

          Activity

            People

            • Assignee:
              ridethepenguin Stefano Costa
              Reporter:
              ridethepenguin Stefano Costa
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: