tune mapserver on oraclespatial

[Bart van den Eijnden (OSGIS)]

Hi,

to log SQL:

1) build Mapserver in debug mode (check with mapserv -v for MSDEBUG)
2) set DEBUG ON keywords on your MAP and LAYER objects
3) set an environment variable for your webserver, called MS_ERRORFILE, 
use for instance stderr so it ends up in Apache's error log. If using 
Apache, use SetEnv in the conf file and restart

You can also use shp2img to get the SQL instead of using Mapserver, 
check the command line options for how to get debug info.

For the Oracle Mapserver reference:
http://mapserver.gis.umn.edu/docs/howto/oracle_spatial_howto

Best regards,
Bart

Sebastian Schmitz schreef:
> Hi,
>
> We want to evaluate the best approach for tuning MapServer on a large 
> table (300.000 rows) in Oracle Spatial. Current idea is to create a 
> partitioned table with each partition having its spatial index. I 
> would like to know, how CONNECTIONTYPE oraclespatial handles the 
> extent to draw when retrieving data from Oracle Spatial. For this, it 
> would help to see the SQL Mapserver generates and uses when accessing 
> Oracle Spatial using CONNECTIONTYPE oraclespatial. How can I do this?
>
>
> Any hints greatly appreciated.
>
> Cheers
>
> Sebastian
>
>
>


-- 
Bart van den Eijnden
OSGIS, Open Source GIS
bartvde at osgis.nl
http://www.osgis.nl