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
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
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:
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
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
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
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