[mapserver-users] ESRI SDE and Linux
LBallard at YesVirginia.org
Wed Jun 13 10:49:15 EDT 2001
Things seem to be working fine on Redhat 7.0 on Intel. I'm using the 8.1
SDE client libraries talking to SDE with Oracle 8.1.6 on a SUN E4500 running
Just as a quick test I looked at the response of 2 layers of the same data
(1 local shapefile and one remote in SDE). This first test used a very
small data set (~1000 polys). The response was slower using SDE (about 1
second for local file and 2 seconds for remote SDE Layer).
I then tried I very large SDE contour layer (~1.3 million lines). I was
amazed. The line SDE layer displayed very rapidly (1-2 seconds depending on
# of features to be drawn). I didn't try to use the file-based data (i.e.,
coverage) so I don't have any comparisons for that but, based on my
experience with medium-sized shape files, SDE would smoke it. It's composed
of 3 coverages which are about 3.6GB total in size. I might try to crank
them into a single shapefile if I have time but...ArcInfo (32bit app)
doesn't like the big files-- that's why it's in 3 coverages currently.
The results were very promising. For CPU Utilization I was seeing a max of
about 50% CPU usage for the 1 second or so it took to draw the SDE Layer
when the amount of features being drawn was intense (contours for highly
mountainous regions zoomed out probably too far). Once I zoomed in on the
data set to a more reasonable viewing extent CPU utilization dropped
significantly (4-8% for about 1 second or less).
The web server is a pitiful Pentium III 500 MHz, 256 MB RAM, Dell Optiplex
running through 100mbs across 2 100mbs switches on the network then into a
GB switch to a GB interface on the SUN box. SDE is running in RAID 5 on SUN
StorEdge disk array (dual fiber connected to E4500) using Fibre-Channel
drives at 10k rpms.
Mapserver was built from the Nightly-build using this configure line:
./configure --with-sde-version=81 --with-sde=../sdeexe81/
Here's the Layer line:
COLOR 200 36 43
COLOR 200 36 43
BACKGROUNDCOLOR 245 240 219
This map service is not publicly accessible yet but will be soon on the
Virginia Economic Development Partnership
901 E. Byrd St., Richmond, Va. 23218
From: Robert Aldridge [mailto:bamarob55 at yahoo.com]
Sent: Wednesday, June 06, 2001 10:17 AM
To: Stephen Lime; MapServer_Users
Subject: Re: [mapserver-users] ESRI SDE and Linux
I downloaded the nightly build this morning. I
configured it with:
Everything appears to go fine. I do a make and once
again everything appears OK. I then copy the mapserv
binary to my cgi-bin directory and it doesn't work. I
kept my old binary around and it works fine. The only
difference between the two is the
This is a Mandrake 7.0 system that has the SDE client
--- Stephen Lime <steve.lime at dnr.state.mn.us> wrote:
> Ok, I just committed changes that allow you to:
> - set the SDE version you want to compile against
> using the configure option --with-sde-version=xx
> where the version number is 80, 81 or whatever
> - compile on Linux against the SDE 8.1 client
> I've compiled things on Solaris 2.6 and Redhat 6.2.
> I've not tested the code on Linux, just Solaris.
> I'll let you folks give it a shot.
> Anyway, nab the CVS version or the latest nightly to
> get at this new code.
> Stephen Lime
> Internet Applications Analyst
> Minnesota DNR
> 500 Lafayette Road
> St. Paul, MN 55155
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
More information about the mapserver-users