[postgis-users] Run on database or not?

Paul Ramsey pramsey at cleverelephant.ca
Tue Nov 24 09:25:47 PST 2009


Also true for C++ people w/ GEOS.

P

On Tue, Nov 24, 2009 at 9:19 AM, Maxime van Noppen <maxime at altribe.org> wrote:
> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



More information about the postgis-users mailing list