<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
h3
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:13.5pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Verdana;
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=SV link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>I have a table with about a million polygon records.
<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>When I will do a getExtent it takes looong time. Five
to ten minutes. I can see it uses the “SELECT SDO_AGGR_MBR(SHAPE) AS GEOM
FROM (SELECT SHAPE FROM SJ_large_sdo);” and it seams as it have to run a
full table scan.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>I’m using mapserver-4.8.1<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>Oracle 10.1 (windows Server)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>MapFile:<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
lang=EN-GB style='font-size:10.0pt;font-family:"Courier New"'>CONNECTION
"wmgis/xxx@wmsi1394"<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
lang=EN-GB style='font-size:10.0pt;font-family:"Courier New"'>CONNECTIONTYPE
oraclespatial <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
lang=EN-GB style='font-size:10.0pt;font-family:"Courier New"'>DATA "shape
FROM (SELECT OBJECTID, SHAPE, KKOD FROM SJ_large_sdo) USING UNIQUE OBJECTID
VERSION 10g" <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>Is there a way to get the extent faster? Don’t
OracleSpatial have some metadata with extent?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>Could I store the extent for the layer in the
MapFile?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>I’m using MapScript to build the logics<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>Thanks in advance<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>/Johan<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:black'>___________________________________<o:p></o:p></span></font></p>
<div>
<h3 style='margin:0cm;margin-bottom:.0001pt'><u1:PERSONNAME ProductID="Johan Hallgren" u2:st="on"><b><font
size=3 color=black face=Arial><span style='font-size:12.0pt;font-family:Arial;
color:black'><u3:PersonName ProductID="Johan Hallgren" u4:st="on">Johan Hallgren<br>
</u3:PersonName></span></font></b><font size=1 color=black face=Arial><span
style='font-size:9.0pt;font-family:Arial;color:black'></u1:PERSONNAME>WM-data</span></font><o:p></o:p></h3>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=1 color=black face=Arial><span style='font-size:9.0pt;font-family:Arial;
color:black'>Pelle Bergs backe 3<br>
<st1:address u5:st="on"><st1:Street u5:st="on">Box</st1:Street> 1938</st1:address>, 791
19 Falun<br>
Tel: 023-844 65 (int: +46-2384465)<br>
Mobil: 070-588 44 28 (int: +46-705884428)<br>
</span></font><u><font size=1 color=blue face=Arial><span style='font-size:
9.0pt;font-family:Arial;color:blue'>johan.e.hallgren</span></font></u><font
size=1 color=black face=Arial><span style='font-size:9.0pt;font-family:Arial;
color:black'><a href="BLOCKED::mailto:johan.e.hallgren@wmdata.com"
target="_blank"
title="mailto:johan.e.hallgren@wmdata.com blocked::mailto:johan.e.hallgren@wmdata.com mailto:johan.e.hallgren@wmdata.com"><span
title="mailto:johan.e.hallgren@wmdata.com">@wmdata.com</span></a></span></font><u><font
size=1 color=blue face=Arial><span style='font-size:9.0pt;font-family:Arial;
color:blue'><br>
</span></font></u><font size=1 color=black face=Arial><span style='font-size:
9.0pt;font-family:Arial;color:black'><a href="BLOCKED::http://www.wmdata.se"
target="_blank"
title="http://www.wmdata.se/ blocked::/exchweb/bin/redir.asp?URL=http://www.wmdata.se/ /exchweb/bin/redir.asp?URL=http://www.wmdata.se/"><span
title="http://www.wmdata.se/">http://www.wmdata.se</span></a></span></font><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:black'><o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>