You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@sedona.apache.org by "Tanel Kiis (Jira)" <ji...@apache.org> on 2022/11/04 13:44:00 UTC

[jira] [Created] (SEDONA-189) Using prepared geometries

Tanel Kiis created SEDONA-189:
---------------------------------

             Summary: Using prepared geometries
                 Key: SEDONA-189
                 URL: https://issues.apache.org/jira/browse/SEDONA-189
             Project: Apache Sedona
          Issue Type: Improvement
            Reporter: Tanel Kiis


With complex polygons using prepared geometries can improve query performance by an order of magnitude.

A test, where I had 1M points and 5k polygons, a simple broadcast join and count with ST_Contains had a performance increase from 1m 20s down to 10s (8x improvement). 





--
This message was sent by Atlassian Jira
(v8.20.10#820010)