[Gdal-dev] Re: Gdal-dev Digest, Vol 30, Issue 25

Geoff Zeiss geoff.zeiss at autodesk.com
Sat Nov 11 12:30:50 EST 2006


Tyler
I expect that I'll be able to help as well, but I don't know my schedule yet.
Geoff
www.geospatial.blogs.com

----- Original Message -----
From: gdal-dev-bounces at lists.maptools.org <gdal-dev-bounces at lists.maptools.org>
To: gdal-dev at lists.maptools.org <gdal-dev at lists.maptools.org>
Sent: Sat Nov 11 12:01:58 2006
Subject: Gdal-dev Digest, Vol 30, Issue 25

Send Gdal-dev mailing list submissions to
	gdal-dev at lists.maptools.org

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.maptools.org/mailman/listinfo/gdal-dev
or, via email, send a message with subject or body 'help' to
	gdal-dev-request at lists.maptools.org

You can reach the person managing the list at
	gdal-dev-owner at lists.maptools.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Gdal-dev digest..."


Today's Topics:

   1. FWTools 1.0.8 (Windows) (Frank Warmerdam)
   2. Re: Performance on using Oracle Client XE (Frank Warmerdam)
   3. GDAL conflicts (copysign() and snprintf() ) (Ozy Sjahputera)
   4. Re: GDAL conflicts (copysign() and snprintf() ) (Frank Warmerdam)


----------------------------------------------------------------------

Message: 1
Date: Fri, 10 Nov 2006 16:31:39 -0500
From: Frank Warmerdam <warmerdam at pobox.com>
Subject: [Gdal-dev] FWTools 1.0.8 (Windows)
To: FWTools <fwtools at lists.maptools.org>
Cc: gdal-dev <gdal-dev at lists.maptools.org>
Message-ID: <4554EFBB.5030404 at pobox.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Folks,

I have built and released a new FWTools 1.0.8 for Windows built from
the latest GDAL, and MapServer source.  This build includes the new GDAL
WCS driver, for those interested in testing it.

   http://www.gdal.org/frmt_wcs.html

The installer can be found at:

   http://www.gdal.org/dl/fwtools/FWTools108.exe

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGeo, http://osgeo.org



------------------------------

Message: 2
Date: Fri, 10 Nov 2006 17:09:35 -0500
From: Frank Warmerdam <warmerdam at pobox.com>
Subject: Re: [Gdal-dev] Performance on using Oracle Client XE
To: Wong Taka <taka_www at yahoo.com.hk>
Cc: gdal-dev at lists.maptools.org
Message-ID: <4554F89F.8020101 at pobox.com>
Content-Type: text/plain; charset=Big5

Wong Taka wrote:
> Dear All
>  
> I am now studing a project about using mapserver to display map.
> In this map, points would be also shown. These points' XY and other info 
> are stored in relational Oracle XE DB. For displaying, these point can 
> be generated in acceptable time.
>  
> However, when I retrieve the Points' attributes by grab the point in 
> map. I found that the loading time is quite long. I have tried to add a 
> index in Oracle XE for the XY in the table. It seems indifferent in 
> performance.

Taka,

I'm not sure what you mean by retreiving the points attribute
by grabbing the point in the map.   Also, are you using the Oracle
OCI driver in OGR, or the CONNECTIONTYPE ORACLE support built into
MapServer?

I will note that the MapServer "query" mechanism is two pass, and
that if going through OCI it requires a seperate SQL SELECT
statement to be executed for each feature fetched.  This is
needless to say fairly expensive.  This is in contrast to how
layers are drawn where a single select is done, and all the
rows are pulled in sequence.

I suspect this is the pit you are falling into.

> Are there any smart way to improve the performance? e.g. did fastCGI 
> work? since I am using IIS to run Mapserver. I wonder.

If it is the problem above, then you are best off avoiding the
two pass query mechanism.  How to do this will depend on your
particulars.  If you are writing a mapscript application, you
may find it better to do something kinds of queries to oracle
directly from your scripting language of choice rather than
through mapserver.

> by the way, I think this post should be post on MAPSERVER mail list, 
> and I have tried also, but it always bound my post back. -_-"

You need to be very careful to subscribe using the email
address you will post from.   I suspect the same thing
happened to you with gdal-dev, and the post was held till
I approved it manually.  There is no manual approval for
the mapserver list as far as I know.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGeo, http://osgeo.org



------------------------------

Message: 3
Date: Fri, 10 Nov 2006 16:55:03 -0600
From: Ozy Sjahputera <sjahputerao at missouri.edu>
Subject: [Gdal-dev] GDAL conflicts (copysign() and snprintf() )
To: gdal-dev at lists.maptools.org
Message-ID: <45550347.4010409 at missouri.edu>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

I am trying to build a C++ project that uses GDAL by including 
gdal_priv.h, cpl_string.h, ogr_spatialref.h and gdalwarper.h.  The 
project was initially created in a Linux environment (Gentoo) and was 
running fine.  While the linux box is being rebuilt, I have to work 
using an XP machine.  The project compiles and runs fine when built 
using VC .NET (2003).  But it throws errors when built using MinGW (with 
Eclipse CDT IDE). 

The two functions cited for these errors are copysign and snprintf. 
After some digging I found that cpl_config.h contains some constants 
that indicates whether these functions are present. 
I am guessing that the settings in cpl_config.h are designed to work 
with VC++ libraries, but problems arises when one uses MinGW libraries.

Any idea how to resolve these conflicts? 

Thanks

oz


------------------------------

Message: 4
Date: Fri, 10 Nov 2006 18:41:15 -0500
From: Frank Warmerdam <warmerdam at pobox.com>
Subject: Re: [Gdal-dev] GDAL conflicts (copysign() and snprintf() )
To: Ozy Sjahputera <sjahputerao at missouri.edu>
Cc: gdal-dev at lists.maptools.org
Message-ID: <45550E1B.5050405 at pobox.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Ozy Sjahputera wrote:
> I am trying to build a C++ project that uses GDAL by including 
> gdal_priv.h, cpl_string.h, ogr_spatialref.h and gdalwarper.h.  The 
> project was initially created in a Linux environment (Gentoo) and was 
> running fine.  While the linux box is being rebuilt, I have to work 
> using an XP machine.  The project compiles and runs fine when built 
> using VC .NET (2003).  But it throws errors when built using MinGW (with 
> Eclipse CDT IDE).
> The two functions cited for these errors are copysign and snprintf. 
> After some digging I found that cpl_config.h contains some constants 
> that indicates whether these functions are present. I am guessing that 
> the settings in cpl_config.h are designed to work with VC++ libraries, 
> but problems arises when one uses MinGW libraries.
> 
> Any idea how to resolve these conflicts?

Oz,

When you build with Visual Studio the gdal/port/cpl_config.h.vc file is
copied over gdal/port/cpl_config.h.  When building on linux, or cygwin
the configure generates the gdal/port/cpl_config.h.

Are you using Cygwin's make, and related stuff for your mingw build?  If
so, you have to be careful to rerun configure after building in the same
tree with visual studio.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGeo, http://osgeo.org



------------------------------

_______________________________________________
Gdal-dev mailing list
Gdal-dev at lists.maptools.org
http://lists.maptools.org/mailman/listinfo/gdal-dev

End of Gdal-dev Digest, Vol 30, Issue 25
****************************************

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20061111/be20c0f7/attachment.html


More information about the Gdal-dev mailing list