[MS4W-Users] SDE workgroup vs shapefile performance thoughts

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

[MS4W-Users] SDE workgroup vs shapefile performance thoughts

Mark  Volz
Hello,
 
We are considering using SDE workgroup as a data source for Mapserver.  Does anyone have any comments about the performance or usability of SDE Workgroup compared to shapefiles?
 
Thanks
 
Mark Volz
GIS Specialist
 
 

_______________________________________________
MS4W-Users mailing list
[hidden email]
http://lists.maptools.org/mailman/listinfo/ms4w-users
Reply | Threaded
Open this post in threaded view
|

Re: SDE workgroup vs shapefile performance thoughts

John Wiley

Just be careful that the users don’t keep you locked out for updating…

 

John Wiley C.Tech.
Senior GIS Specialist
Engineering Department
City of Victoria
250-361-0307
[hidden email]


From: [hidden email] [mailto:[hidden email]] On Behalf Of Mark Volz
Sent: Thursday, Dec 15, 2011 11:26 AM
To: [hidden email]
Subject: [MS4W-Users] SDE workgroup vs shapefile performance thoughts

 

Hello,

 

We are considering using SDE workgroup as a data source for Mapserver.  Does anyone have any comments about the performance or usability of SDE Workgroup compared to shapefiles?

 

Thanks

 

Mark Volz

GIS Specialist

 

 


_______________________________________________
MS4W-Users mailing list
[hidden email]
http://lists.maptools.org/mailman/listinfo/ms4w-users
Reply | Threaded
Open this post in threaded view
|

Re: SDE workgroup vs shapefile performance thoughts

Smith, Michael ERDC-CRREL-NH
In reply to this post by Mark Volz
Mark,

I don't know what you're backend is but I can report that Oracle Spatial works very well. We use it extensively.

ESRI has announced its intention to discontinue SDE in favor of its new SDS product (Spatial Data Server). I don't know that I would be planning on SDE long term

Mike

-- 
Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers

From: Mark Volz <[hidden email]>
Date: Thu, 15 Dec 2011 19:25:36 +0000
To: "[hidden email]" <[hidden email]>
Subject: [MS4W-Users] SDE workgroup vs shapefile performance thoughts

Hello,
 
We are considering using SDE workgroup as a data source for Mapserver.  Does anyone have any comments about the performance or usability of SDE Workgroup compared to shapefiles?
 
Thanks
 
Mark Volz
GIS Specialist
 
 
_______________________________________________ MS4W-Users mailing list [hidden email] http://lists.maptools.org/mailman/listinfo/ms4w-users

_______________________________________________
MS4W-Users mailing list
[hidden email]
http://lists.maptools.org/mailman/listinfo/ms4w-users
Reply | Threaded
Open this post in threaded view
|

Re: SDE workgroup vs shapefile performance thoughts

Stephen Woodbridge
In reply to this post by Mark Volz
On 12/15/2011 2:25 PM, Mark Volz wrote:
> Hello,
> We are considering using SDE workgroup as a data source for Mapserver.
> Does anyone have any comments about the performance or usability of SDE
> Workgroup compared to shapefiles?

Mark,

In general, shapefiles are the fastest method of accessing data.
Obviously, there are exceptions to this. In some database applications
that have good spatial filtering or relational filtering depend on your
specific use case, you will find some advantages of shapefiles.

In an ideal world you would want to open a shapefile and read all the
data from that shapefile and be done. In this model it is fastest.
Typically there are overhead cost to making a connection and these can
be significant in some cases. Using fast-cgi and CONNECTION_CLOSE=DEFER
in the layer will help mitigate these costs.

HTH,
   -Steve W
_______________________________________________
MS4W-Users mailing list
[hidden email]
http://lists.maptools.org/mailman/listinfo/ms4w-users
Reply | Threaded
Open this post in threaded view
|

Re: SDE workgroup vs shapefile performance thoughts

jmckenna
Administrator
On 11-12-15 3:52 PM, Stephen Woodbridge wrote:
> On 12/15/2011 2:25 PM, Mark Volz wrote:
>> Hello,
>> We are considering using SDE workgroup as a data source for Mapserver.
>> Does anyone have any comments about the performance or usability of SDE
>> Workgroup compared to shapefiles?
>

You might get an understanding of speed comparisons (of flat files vs
DB) by reviewing some of the past WMS benchmarking numbers (e.g. in 2010
shp and Postgres/PostGIS was compared:
http://www.slideshare.net/gatewaygeomatics.com/wms-performance-shootout-2010).

But as Mike said they rely on Oracle/SDE/MapServer heavily and are very
happy with performance.

-jeff




--
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/


_______________________________________________
MS4W-Users mailing list
[hidden email]
http://lists.maptools.org/mailman/listinfo/ms4w-users