[postgis-users] PostGIS 2.0 Topology

[Christophe Vergon]

Hi,

Not a question but a tip. How to draw faster faces in a box:.

The first methode (very slow):

SELECT st_AsBinary(st_GetFaceGeometry('topocommune',element_id)) AS 
poly, topogeo_id FROM topocommune.relation WHERE ((layer_id=:lid) AND 
(st_GetFaceGeometry('topocommune',element_id) && st_LineFromText(:rg," & 
SRID & ")));

The second way, faster

  SELECT st_AsBinary(st_GetFaceGeometry('topocommune',face_id)) FROM 
topocommune.face,topocommune.relation WHERE mbr && st_linefromtext(:rg," 
& SRID & ") AND layer_id=:lid AND face_id=element_id;

Hope it will help

Christophe

: