tune mapserver on oraclespatial

[Michael Smith]

One of the easiest ways is to just introduce a small syntax error in your
data statement (change the tablename or something). Then Mapserver will
print the spatial sql statement to the screen (using the cgi version)

Mike Smith

-- 
Michael Smith
RSGIS Center
ERDC - CRREL
US Army Corps of Engineers





On 12/8/06 11:31 AM, "Sebastian Schmitz" <sschmitz at KARTAGO.DE> wrote:

> 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
> 
>