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
[EMAIL PROTECTED]
http://www.kartago.de
________________________________________________________
