<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hello Mike, <br>
<br>
sorry for the late response ( i was on short vacation trip over the
long weekend here in germany ).<br>
Thank you very much for investigating that and creating the ticket.
I made a short test and can confirm that changing the scrollable
cursor to default brings the performance back also in my test cases
( 32 seconds back to 15 seconds for the layer with 200000 points
from a view ). I will watching at the ticket and hopefully somebody
can explain in the near future this problem and solve this, so that
we can take the new trunk version for our project.<br>
<br>
best regards <br>
<br>
Holger <br>
<br>
Am 02.06.2011 13:22, schrieb Smith, Michael ERDC-CRREL-NH:
<blockquote cite="mid:CA0CEABD.243AA%25michael.smith@usace.army.mil"
type="cite">
<title>Re: [mapserver-dev] Performance problem with oracle spatial
in mapserver 6</title>
<font face="Calibri, Verdana, Helvetica, Arial"><span
style="font-size: 11pt;">All,<br>
<br>
I’ve created ticket #3905 ( </span></font><font
color="#0000ff"><font size="2"><font face="Consolas, Courier
New, Courier"><span style="font-size: 10pt;"><u><a
moz-do-not-send="true"
href="http://trac.osgeo.org/mapserver/ticket/3905">http://trac.osgeo.org/mapserver/ticket/3905</a></u></span></font></font><font
face="Calibri, Verdana, Helvetica, Arial"><span
style="font-size: 11pt;"> </span></font></font><font
face="Calibri, Verdana, Helvetica, Arial"><span
style="font-size: 11pt;">) to track the issue.<br>
<br>
Mike<br>
<br>
<br>
-- <br>
Michael Smith<br>
Remote Sensing/GIS Center<br>
US Army Corps of Engineers<br>
<br>
<br>
<br>
On 6/1/11 5:20 PM, "Michael Smith" <<a
moz-do-not-send="true" href="Michael.Smith@usace.army.mil">Michael.Smith@usace.army.mil</a>>
wrote:<br>
<br>
</span></font>
<blockquote><font face="Calibri, Verdana, Helvetica, Arial"><span
style="font-size: 11pt;">All,<br>
<br>
I’ve traced the performance hit in Oracle Spatial to the use
of a scrollable cursor in the main execute statement (trunk
Line 2210).<br>
<br>
Changing from <br>
<br>
</span></font><font size="2"><font face="Consolas, Courier
New, Courier"><span style="font-size: 10pt;">OCIStmtExecute(
hand->svchp, sthand->stmthp, hand->errhp,
(ub4)ARRAY_SIZE, (ub4)0, (OCISnapshot *)NULL, (OCISnapshot
*)NULL, (ub4) OCI_STMT_SCROLLABLE_READONLY ) )<br>
</span></font></font><font face="Calibri, Verdana,
Helvetica, Arial"><span style="font-size: 11pt;"> <br>
To <br>
<br>
</span></font><font size="2"><font face="Consolas, Courier
New, Courier"><span style="font-size: 10pt;">OCIStmtExecute(
hand->svchp, sthand->stmthp, hand->errhp,
(ub4)ARRAY_SIZE, (ub4)0, (OCISnapshot *)NULL, (OCISnapshot
*)NULL, (ub4)OCI_DEFAULT ) )<br>
</span></font></font><font face="Calibri, Verdana,
Helvetica, Arial"><span style="font-size: 11pt;"> <br>
On a point layer with 78K points decreased time from 13.033s
to 8.509s, which is almost exactly the times I measured from
rev 9295 and previous.<br>
<br>
The next obvious question is, are there specific use cases
where the scrollable cursor needs to be used? For straight
cgi drawing (wms and mode=map), it works fine but I haven’t
investigated the various query modes, mapscript, etc. Was
there a specific reason that the cursor type was changed to
SCROLLABLE?<br>
<br>
Mike<br>
<br>
</span></font></blockquote>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Holger Schiebold
____________________
codematix GmbH
Felsbachstrasse 5/7
D-07745 Jena
Tel. +49 (3641) 3038-34
<a class="moz-txt-link-abbreviated" href="http://www.codematix.de">www.codematix.de</a>
</pre>
</body>
</html>