tune mapserver on oraclespatial

[Sebastian Schmitz]

Hi
thanks for help with step 1 of my question - getting the SQL Mapserver 
uses. My Mapserver (4.8.3) does not print anything but failed to draw 
layer onto the screen, but setting debug flag and setting an 
MS_ERRORFILE env-variable worked out fine.
So, now I have the SQL I may as well post it here and ask for comments 
on tuning options for a large table (300.000 rows):

SELECT KUNNR, GEOM FROM     (< subselect >)  WHERE SDO_FILTER( GEOM, 
        MDSYS.SDO_GEOMETRY(2003, 8307, 
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(4.04520417,48.6727777,9.82231387,51.398884) 
),
        'querytype=window') = 'TRUE'

Our current idea is to partition the table by x and y values from 
SDO_GEOMETRY and put spatial indices onto each of these partitions. 
Status quo is that we only have one spatial index for the whole table..

Feedback appreciated

Cheers

Sebastian




Michael Smith schrieb:
> 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
>
>   

-- 
KARTA.GO Gesellschaft für raumbezogenes Informationsmanagement mbH

Siemensstraße 8
53121 Bonn

Sebastian Schmitz
Projektleiter

fon: +49 (0) 228 / 9 45 99 91
fax: +49 (0) 228 / 9 45 99 93
sschmitz at kartago.de
http://www.kartago.de
________________________________________________________