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

[Holger Schiebold]

Hello Mike,

sorry for the late response ( i was on short vacation trip over the long 
weekend here in germany ).
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.

best regards

Holger

Am 02.06.2011 13:22, schrieb 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
>


-- 
Holger Schiebold


____________________
codematix GmbH
Felsbachstrasse 5/7
D-07745 Jena
Tel. +49 (3641) 3038-34
www.codematix.de

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-dev/attachments/20110606/a1b19587/attachment.html