[postgis-users] Run on database or not?

Maxime van Noppen maxime at altribe.org
Tue Nov 24 09:19:51 PST 2009


Paul Ramsey wrote:
> Martin++. If you don't mind the complexity of writing your own little
> query engine, having all the features in memory, as JTS
> PreparedGeometries, with an STRTree on top of them (assuming your
> collection is more than a few items) you'll get better performance
> than in PostGIS. PostGIS has to prepare geometries one per query, the
> custom app can have them prepared once at the start and used by
> queries ever after.

Is this also true for C++/geos ? I saw STRTrees but never tried to use them.

-- 
Maxime



More information about the postgis-users mailing list