[mapserver-dev] Performance problem with oracle spatial in mapserver 6

[Smith, Michael ERDC-CRREL-NH]

All,

I¹ve created ticket #3905 ( http://trac.osgeo.org/mapserver/ticket/3905 ) to
track the issue.

Mike


-- 
Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers



On 6/1/11 5:20 PM, "Michael Smith" <Michael.Smith at usace.army.mil> wrote:

> All,
> 
> I¹ve traced the performance hit in Oracle Spatial to the use of a scrollable
> cursor in the main execute statement (trunk Line 2210).
> 
> Changing from 
> 
>   OCIStmtExecute( hand->svchp, sthand->stmthp, hand->errhp, (ub4)ARRAY_SIZE,
> (ub4)0, (OCISnapshot *)NULL, (OCISnapshot *)NULL, (ub4)
> OCI_STMT_SCROLLABLE_READONLY ) )
>           
> To 
> 
>   OCIStmtExecute( hand->svchp, sthand->stmthp, hand->errhp, (ub4)ARRAY_SIZE,
> (ub4)0, (OCISnapshot *)NULL, (OCISnapshot *)NULL, (ub4)OCI_DEFAULT ) )
>           
> 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.
> 
> 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?
> 
> Mike
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-dev/attachments/20110602/567b49e0/attachment-0001.html