<HTML>
<HEAD>
<TITLE>Re: [mapserver-dev] Performance problem with oracle spatial in mapserver 6</TITLE>
</HEAD>
<BODY>
<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 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 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>
</BODY>
</HTML>