[mapserver-users] Oracle native / Oracle OGR

2009-07-10 Thread YOUNESS ELMEDRAOUI
Hello everybody,i have a question:what's the difference between aconnection to oracle DB with native oraclespatial and OGR?performance, ...??thanksBest regardsYounessELMEDRAOUILes informations figurant sur cet e-mail ont un caractère strictement confidentiel et sont exclusivement adressées au

Re: [mapserver-users] Oracle native / Oracle OGR

2009-07-10 Thread Frank Warmerdam
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

Re: [mapserver-users] Oracle native / Oracle OGR

2009-07-10 Thread Schlagel, Joel D IWR
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 warmer...@pobox.com wrote: YOUNESS ELMEDRAOUI wrote: Hello everybody, i have a question:

Re: [mapserver-users] Oracle native / Oracle OGR

2009-07-10 Thread Tamas Szekeres
Hi, I've already tested these 2 methods with a couple of mapfiles on Windows, but I haven't found significant differences in the rendering speed. In my special case the OGR option was more compelling, since in this case we can use STYLEITEM AUTO option. Therefore I could easily migrate all the

Re: [mapserver-users] Oracle native / Oracle OGR

2009-07-10 Thread Thomas Bonfort
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

Re: [mapserver-users] Oracle native / Oracle OGR

2009-07-10 Thread Smith, Michael ERDC-CRREL-NH
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.bonf...@camptocamp.com wrote: some of our clients have come up with a few quirks in the native

Re: [mapserver-users] Oracle native / Oracle OGR

2009-07-10 Thread 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-NHmichael.sm...@usace.army.mil wrote: Thomas, To solve the second issue, use a