About Mapserver Native Oracle support and OGR Oracle support

[Fernando Simon]

Hi Robert,
    Just to complete the Bart answer, this feature I finished in the 4.4 
version of Mapserver.
    Now with native support you can query data from Oracle Spatial using 
Mapserver without problems. You can use query functions in Mapscript, 
query mode in CGI, WMS/WFS requests....
    Regards.

------------------------------------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada - Brazil
http://www.univali.br/g10 - UNIVALI/CTTMAR
------------------------------------------------------------------------
   

Robert oude Lohuis wrote:

>True, but there is a difference:
>
>The native support does not have the capability to get administrative data
>from the database, but delivers only the geometry data. OGR does have
>support for queries which deliver data of other database-columns other than
>the geometry column.
>
>But, as Bart already mentioned, this comes with a price. The performance
>decreased in our case with a factor 2.
>
>greetz,
>
>Robert.
>
>On Mon, 24 Oct 2005 12:05:25 +0200, Bart van den Eijnden
><BEN at SYNCERA-ITSOLUTIONS.NL> wrote:
>
>  
>
>>I think the Mapserver native would be the preferred way. It should have the
>>    
>>
>best performance, and it has the same features as the OGR one. Note that the
>OGR OCI driver was mostly developed for writing data and not so much for
>reading (so it might not be completely optimized for that).
>  
>
>>Best regards,
>>Bart
>>
>>Bart van den Eijnden
>>Syncera IT Solutions
>>Postbus 270
>>2600 AG  DELFT
>>
>>tel.nr.: 015-7512436
>>email: BEN at Syncera-ITSolutions.nl
>>
>>    
>>
>>>>>Jukka Sirviö <Jukka.Sirvio at ARBONAUT.COM> 24-10-2005 10:24 >>>
>>>>>          
>>>>>
>>Hello!
>>Does anyone have a suggestion which is the preferred way for getting the
>>spatial data from Oracle? Is it Mapserver Native support or is it through
>>OGR / gdal? What are the drawbacks / benefits for both of these? I already
>>know that if I use ogr approach I have to compile gdal and then compile
>>mapserver for this version of gdal.
>>
>>I quess that Mapserver native approach is more widely used?
>>
>>
>>Yours:
>>Jukka
>>    
>>
>
>  
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20051024/58e80f91/attachment.htm>