OK.
So for now, working with a large topology data set is not practical. Some
processing should not be a problem, if it operates on the primitives, which are
indexed.
-----
I'm not sure to understand all of the problem, the way I use to link
Buissnes Object (here "tronfluv" ) and Primitives in a request is as folow
SELECT st_AsBinary(st_GetFaceGeometry('topocommune',face_id)),idtronfluv
FROM topocommune.face,topocommune.relation, schemaname.tronfluv WHERE
layer_id=:lid AND mbr && st_LineFromText(:rg,srid) AND
face_id=element_id AND (the_topo).id=topogeo_id;
Nota : :rg parameter who describe a polyline (a rectangle in fact).
It works well and relatively fast with a large topology dataset (23 518
Buissnes Object "tronfluv" in my Database)
Christophe
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users