[mapserver-users] Oracle native / Oracle OGR

[Thomas Bonfort]

this can be a solution in some cases yes. In ours the the query is
dynamically built and passed on through the url, so it isn't as simple
as that.

thomas

On Fri, Jul 10, 2009 at 21:29, Smith, Michael
ERDC-CRREL-NH<michael.smith at usace.army.mil> wrote:
> Thomas,
>
> To solve the second issue, use a view.
>
> Mike
>
>
> --
> Michael Smith
> Remote Sensing GIS Center
> CRREL - ERDC
> US Army Corps of Engineers
> Hanover, NH
>
>
>
>
> On 7/10/09 2:38 PM, "Thomas Bonfort" <thomas.bonfort at camptocamp.com> wrote:
>
>> some of our clients have come up with a few quirks in the native
>> oracle driver that should be taken into account:
>>
>> * the strings storing the fields returned by the database have a fixed
>> length in mapserver, so that might have to be overridden at compile
>> time if you are planning to return data longer than a certain value
>> (2048 bytes from memory). For normal map rendering this shouldn't be a
>> problem, but problems may arise when doing wfs queries and returning a
>> paragraph of text for example in an attribute.
>>
>> * I haven't investigated this much more, but we've also had problems
>> with long query strings (we're talking DATA mapfile strings of several
>> kbytes here)
>>
>> regards,
>>
>> thomas
>>
>> www.camptocamp.com
>> +33 4 79 26 57 97
>>
>>
>>
>> On Fri, Jul 10, 2009 at 17:59, Schlagel, Joel D
>> IWR<joel.d.schlagel at usace.army.mil> wrote:
>>> For what it's worth - we've used the oracle direct connect in a production
>>> environment all day, every day for several years with no quirks to report.
>>>
>>> -joel
>>>
>>>
>>>
>>> On 7/10/09 11:36 AM, "Frank Warmerdam" <warmerdam at pobox.com> wrote:
>>>
>>>> YOUNESS ELMEDRAOUI wrote:
>>>>> Hello everybody,
>>>>>
>>>>> i have a question:
>>>>> what's the difference between a connection to oracle DB with native
>>>>> oraclespatial and OGR?
>>>>> performance, ...??
>>>>
>>>> Youness,
>>>>
>>>> Generally speaking the direct connection should be faster since it avoids
>>>> a lot of OGR overhead.  They are completely distict implementations so
>>>> you might find each has quirks and strengths though I can't really identify
>>>> them off hand.
>>>>
>>>> Best regards,
>>>
>>>
>>> -joel
>>>
>>> --
>>> Joel D. Schlagel
>>> US Army Engineer Institute for Water Resources
>>> http://www.iwr.usace.army.mil
>>>
>>>
>>> _______________________________________________
>>> mapserver-users mailing list
>>> mapserver-users at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>>>
>> _______________________________________________
>> mapserver-users mailing list
>> mapserver-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>