Here is the extract from the statement log: hope I understood what you
asked for.
.................
2007-07-18 15:04:39 LOG: statement: FETCH ALL in mycursor
2007-07-18 15:04:39 LOG: statement: CLOSE mycursor
2007-07-18 15:04:39 LOG: statement: BEGIN
2007-07-18 15:04:39 LOG: statement: DECLARE mycursor BINARY CURSOR FOR
SELECT
"classe"::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text
from arch_geo.dusaf WHERE the_geom && setSRID('BOX3D(1417000
4900950,1715100 5199050)'::BOX3D, 26591 )
2007-07-18 15:04:39 LOG: statement: FETCH ALL in mycursor
2007-07-18 15:04:58 LOG: statement: CLOSE mycursor
2007-07-18 15:04:58 LOG: statement: BEGIN
.....................
Drawing is much faster when I zoom in, the problem is just when I load all
the data.
Thanks,
Francesco Pirotti
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
