<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6618.4">
<TITLE>Re: Gdal-dev Digest, Vol 30, Issue 25</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Tyler<BR>
I expect that I'll be able to help as well, but I don't know my schedule yet.<BR>
Geoff<BR>
www.geospatial.blogs.com<BR>
<BR>
----- Original Message -----<BR>
From: gdal-dev-bounces@lists.maptools.org <gdal-dev-bounces@lists.maptools.org><BR>
To: gdal-dev@lists.maptools.org <gdal-dev@lists.maptools.org><BR>
Sent: Sat Nov 11 12:01:58 2006<BR>
Subject: Gdal-dev Digest, Vol 30, Issue 25<BR>
<BR>
Send Gdal-dev mailing list submissions to<BR>
gdal-dev@lists.maptools.org<BR>
<BR>
To subscribe or unsubscribe via the World Wide Web, visit<BR>
<A HREF="http://lists.maptools.org/mailman/listinfo/gdal-dev">http://lists.maptools.org/mailman/listinfo/gdal-dev</A><BR>
or, via email, send a message with subject or body 'help' to<BR>
gdal-dev-request@lists.maptools.org<BR>
<BR>
You can reach the person managing the list at<BR>
gdal-dev-owner@lists.maptools.org<BR>
<BR>
When replying, please edit your Subject line so it is more specific<BR>
than "Re: Contents of Gdal-dev digest..."<BR>
<BR>
<BR>
Today's Topics:<BR>
<BR>
1. FWTools 1.0.8 (Windows) (Frank Warmerdam)<BR>
2. Re: Performance on using Oracle Client XE (Frank Warmerdam)<BR>
3. GDAL conflicts (copysign() and snprintf() ) (Ozy Sjahputera)<BR>
4. Re: GDAL conflicts (copysign() and snprintf() ) (Frank Warmerdam)<BR>
<BR>
<BR>
----------------------------------------------------------------------<BR>
<BR>
Message: 1<BR>
Date: Fri, 10 Nov 2006 16:31:39 -0500<BR>
From: Frank Warmerdam <warmerdam@pobox.com><BR>
Subject: [Gdal-dev] FWTools 1.0.8 (Windows)<BR>
To: FWTools <fwtools@lists.maptools.org><BR>
Cc: gdal-dev <gdal-dev@lists.maptools.org><BR>
Message-ID: <4554EFBB.5030404@pobox.com><BR>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed<BR>
<BR>
Folks,<BR>
<BR>
I have built and released a new FWTools 1.0.8 for Windows built from<BR>
the latest GDAL, and MapServer source. This build includes the new GDAL<BR>
WCS driver, for those interested in testing it.<BR>
<BR>
<A HREF="http://www.gdal.org/frmt_wcs.html">http://www.gdal.org/frmt_wcs.html</A><BR>
<BR>
The installer can be found at:<BR>
<BR>
<A HREF="http://www.gdal.org/dl/fwtools/FWTools108.exe">http://www.gdal.org/dl/fwtools/FWTools108.exe</A><BR>
<BR>
Best regards,<BR>
--<BR>
---------------------------------------+--------------------------------------<BR>
I set the clouds in motion - turn up | Frank Warmerdam, warmerdam@pobox.com<BR>
light and sound - activate the windows | <A HREF="http://pobox.com/~warmerdam">http://pobox.com/~warmerdam</A><BR>
and watch the world go round - Rush | President OSGeo, <A HREF="http://osgeo.org">http://osgeo.org</A><BR>
<BR>
<BR>
<BR>
------------------------------<BR>
<BR>
Message: 2<BR>
Date: Fri, 10 Nov 2006 17:09:35 -0500<BR>
From: Frank Warmerdam <warmerdam@pobox.com><BR>
Subject: Re: [Gdal-dev] Performance on using Oracle Client XE<BR>
To: Wong Taka <taka_www@yahoo.com.hk><BR>
Cc: gdal-dev@lists.maptools.org<BR>
Message-ID: <4554F89F.8020101@pobox.com><BR>
Content-Type: text/plain; charset=Big5<BR>
<BR>
Wong Taka wrote:<BR>
> Dear All<BR>
> <BR>
> I am now studing a project about using mapserver to display map.<BR>
> In this map, points would be also shown. These points' XY and other info<BR>
> are stored in relational Oracle XE DB. For displaying, these point can<BR>
> be generated in acceptable time.<BR>
> <BR>
> However, when I retrieve the Points' attributes by grab the point in<BR>
> map. I found that the loading time is quite long. I have tried to add a<BR>
> index in Oracle XE for the XY in the table. It seems indifferent in<BR>
> performance.<BR>
<BR>
Taka,<BR>
<BR>
I'm not sure what you mean by retreiving the points attribute<BR>
by grabbing the point in the map. Also, are you using the Oracle<BR>
OCI driver in OGR, or the CONNECTIONTYPE ORACLE support built into<BR>
MapServer?<BR>
<BR>
I will note that the MapServer "query" mechanism is two pass, and<BR>
that if going through OCI it requires a seperate SQL SELECT<BR>
statement to be executed for each feature fetched. This is<BR>
needless to say fairly expensive. This is in contrast to how<BR>
layers are drawn where a single select is done, and all the<BR>
rows are pulled in sequence.<BR>
<BR>
I suspect this is the pit you are falling into.<BR>
<BR>
> Are there any smart way to improve the performance? e.g. did fastCGI<BR>
> work? since I am using IIS to run Mapserver. I wonder.<BR>
<BR>
If it is the problem above, then you are best off avoiding the<BR>
two pass query mechanism. How to do this will depend on your<BR>
particulars. If you are writing a mapscript application, you<BR>
may find it better to do something kinds of queries to oracle<BR>
directly from your scripting language of choice rather than<BR>
through mapserver.<BR>
<BR>
> by the way, I think this post should be post on MAPSERVER mail list,<BR>
> and I have tried also, but it always bound my post back. -_-"<BR>
<BR>
You need to be very careful to subscribe using the email<BR>
address you will post from. I suspect the same thing<BR>
happened to you with gdal-dev, and the post was held till<BR>
I approved it manually. There is no manual approval for<BR>
the mapserver list as far as I know.<BR>
<BR>
Best regards,<BR>
--<BR>
---------------------------------------+--------------------------------------<BR>
I set the clouds in motion - turn up | Frank Warmerdam, warmerdam@pobox.com<BR>
light and sound - activate the windows | <A HREF="http://pobox.com/~warmerdam">http://pobox.com/~warmerdam</A><BR>
and watch the world go round - Rush | President OSGeo, <A HREF="http://osgeo.org">http://osgeo.org</A><BR>
<BR>
<BR>
<BR>
------------------------------<BR>
<BR>
Message: 3<BR>
Date: Fri, 10 Nov 2006 16:55:03 -0600<BR>
From: Ozy Sjahputera <sjahputerao@missouri.edu><BR>
Subject: [Gdal-dev] GDAL conflicts (copysign() and snprintf() )<BR>
To: gdal-dev@lists.maptools.org<BR>
Message-ID: <45550347.4010409@missouri.edu><BR>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed<BR>
<BR>
I am trying to build a C++ project that uses GDAL by including<BR>
gdal_priv.h, cpl_string.h, ogr_spatialref.h and gdalwarper.h. The<BR>
project was initially created in a Linux environment (Gentoo) and was<BR>
running fine. While the linux box is being rebuilt, I have to work<BR>
using an XP machine. The project compiles and runs fine when built<BR>
using VC .NET (2003). But it throws errors when built using MinGW (with<BR>
Eclipse CDT IDE).<BR>
<BR>
The two functions cited for these errors are copysign and snprintf.<BR>
After some digging I found that cpl_config.h contains some constants<BR>
that indicates whether these functions are present.<BR>
I am guessing that the settings in cpl_config.h are designed to work<BR>
with VC++ libraries, but problems arises when one uses MinGW libraries.<BR>
<BR>
Any idea how to resolve these conflicts?<BR>
<BR>
Thanks<BR>
<BR>
oz<BR>
<BR>
<BR>
------------------------------<BR>
<BR>
Message: 4<BR>
Date: Fri, 10 Nov 2006 18:41:15 -0500<BR>
From: Frank Warmerdam <warmerdam@pobox.com><BR>
Subject: Re: [Gdal-dev] GDAL conflicts (copysign() and snprintf() )<BR>
To: Ozy Sjahputera <sjahputerao@missouri.edu><BR>
Cc: gdal-dev@lists.maptools.org<BR>
Message-ID: <45550E1B.5050405@pobox.com><BR>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed<BR>
<BR>
Ozy Sjahputera wrote:<BR>
> I am trying to build a C++ project that uses GDAL by including<BR>
> gdal_priv.h, cpl_string.h, ogr_spatialref.h and gdalwarper.h. The<BR>
> project was initially created in a Linux environment (Gentoo) and was<BR>
> running fine. While the linux box is being rebuilt, I have to work<BR>
> using an XP machine. The project compiles and runs fine when built<BR>
> using VC .NET (2003). But it throws errors when built using MinGW (with<BR>
> Eclipse CDT IDE).<BR>
> The two functions cited for these errors are copysign and snprintf.<BR>
> After some digging I found that cpl_config.h contains some constants<BR>
> that indicates whether these functions are present. I am guessing that<BR>
> the settings in cpl_config.h are designed to work with VC++ libraries,<BR>
> but problems arises when one uses MinGW libraries.<BR>
><BR>
> Any idea how to resolve these conflicts?<BR>
<BR>
Oz,<BR>
<BR>
When you build with Visual Studio the gdal/port/cpl_config.h.vc file is<BR>
copied over gdal/port/cpl_config.h. When building on linux, or cygwin<BR>
the configure generates the gdal/port/cpl_config.h.<BR>
<BR>
Are you using Cygwin's make, and related stuff for your mingw build? If<BR>
so, you have to be careful to rerun configure after building in the same<BR>
tree with visual studio.<BR>
<BR>
Best regards,<BR>
--<BR>
---------------------------------------+--------------------------------------<BR>
I set the clouds in motion - turn up | Frank Warmerdam, warmerdam@pobox.com<BR>
light and sound - activate the windows | <A HREF="http://pobox.com/~warmerdam">http://pobox.com/~warmerdam</A><BR>
and watch the world go round - Rush | President OSGeo, <A HREF="http://osgeo.org">http://osgeo.org</A><BR>
<BR>
<BR>
<BR>
------------------------------<BR>
<BR>
_______________________________________________<BR>
Gdal-dev mailing list<BR>
Gdal-dev@lists.maptools.org<BR>
<A HREF="http://lists.maptools.org/mailman/listinfo/gdal-dev">http://lists.maptools.org/mailman/listinfo/gdal-dev</A><BR>
<BR>
End of Gdal-dev Digest, Vol 30, Issue 25<BR>
****************************************<BR>
</FONT>
</P>
</BODY>
</HTML>