[postgis-users] PostGIS vs. JTS

Markus Schaber schabi at logix-tt.com
Mon Aug 7 08:19:37 PDT 2006


Hi, Baris,

Baris YILMAZ wrote:

> I'm doing my thesis about a GIS. I use, PostGIS as my Database
> Extension. It works great.
> 
> But as far as I want to make some queries with the Spatial Data in the
> Database, it seems to me, that
> using postgis for these queries, takes longer. Each time, a new
> connection has to be made to the Database. Therefore, I decided to use
> Java Topology Suite for the queries. It seemed to be very faster for
> doing spatial queries. (The queries I execute, are rather simple, like
> find the distance between two points, or, check wheter two geometries
> intersect )
> 
> Can you confirm me, that, using JTS for spatial queries goes faster than
> using PostGIS? Can you please share your experience about this matter?

Most of the PostGIS geometry processing is based on JTS (or its C++ port
GEOS), so it basically uses the same algorithms.

For geometry operations in your local application, using PostGIS means
that all your data has to be serialized, transferred to the database,
deserialized, and the result the other way round. This is a large
overhead for most operations, so running a local JTS in your application
will be faster for those cases.

HTH,
Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org



More information about the postgis-users mailing list