Performance benefits of using USE_PARQUET_GEO_TYPES=yes

Michael Smith via gdal-dev <[email protected]>
Newsgroups gmane.comp.gis.gdal.devel
Message-ID <[email protected]> 
Just a note for others that I've found for querying parquet files with GDAL 3.12.2 and libarrow 23 that USE_PARQUET_GEO_TYPES=yes, and in my case, since geometries are in 4326, using EDGES=spherical, that the performance has doubled. 

Query time with spatial filter:

GDAL Geom as wkb:     time: 0:01:37.471977
GDAL Geom as geo:      time: 0:00:47.025982
DuckDB geom as wkb:  time: 0:00:15.171584
DuckDB geom as geo:   time: 0:00:07.801056



-- 

Michael Smith 
RSGIS Center – ERDC CRREL NH 
US Army Corps 






_______________________________________________
gdal-dev mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/gdal-dev
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.