Hello...
I developed a WebGIS application trought cartoweb (www.cartoweb.org). My
aim is to display a large numerber of points for each couple of (USER,
ROLE) that login into the system...
The problem is they are more than 50.000 points and even if I set
MINSCALE, MAXSCALE to display them, the time for queries is to much and
the whole application is slow.
Is there a way to speed the interaction beetween Mapserver and PostGIS?
Cosider that I created spatial and no-spatial indexes on points talbe in
PostgreSQL and I make queries from php\mapscript as following:
$layer1 = new LayerOverlay();
$layer1->name = "my_layer";
$layer1->data = "the_geom from my_table as foo using unique
gid using SRID=-1" ;
$layer1->filter = "field1 = 'Y' and field2 = '$myValue' " ;
gid is PK...
Thanks for your help !
--
Fabio D'Ovidio
Geospatial solutions
INOVA s.r.l.
Web : http://www.inovaos.it
Tel.: 081 197 57 600
mail: [EMAIL PROTECTED]
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
