<br><br><div class="gmail_quote">2011/6/1 Smith, Michael ERDC-CRREL-NH <span dir="ltr"><<a href="mailto:michael.smith@usace.army.mil">michael.smith@usace.army.mil</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div>
<font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size:11pt"></span></font><font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size:11pt"><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?<div class="im">
<br></div></span></font></div></blockquote><div><br>Mike,<br><br>This issue is possibly related to the single pass query implementation in the Oracle driver. I've run into a similar issue with mssql2008 when trying to implement the same. In my opinion there's no need to make the cursor scrollable in most cases (like in the normal drawing) since it affects the overall performance in a harmful way. With regards to mssql2008 I've ended up with a second fetch for the query results and use the forward only cursor to get the shapes sequentially then. This results in 2 fetch instead of one but avoid scrollable cursors at all.<br>
<br>Best regards,<br><br>Tamas<br><br></div></div>