[postgis-users] newby performance load to mapserver compared toshapefile

[francesco.pirotti at unipd.it]

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