Hexagon Geospatial


Wondering how others have configured their ERDAS APOLLO server or what data they are crawling? The ERDAS APOLLO Discussion board is a place to find information, share ideas and more. Join the community, connect, contribute and share.
Showing results for 
Search instead for 
Do you mean 
Occasional Contributor
Posts: 18
Registered: ‎06-01-2016
Accepted Solution

Apollo wms Shape vs SQL

Hi there... Here is another question for you guys, particularly for the tech guys at hexagon. 


Are there any benchmarks, documentation or by experience does anyone knows what´s faster, a WMS service generated from shape file or a SQL server one?

Technical Evangelist
Posts: 847
Registered: ‎07-30-2015

Re: Apollo wms Shape vs SQL

[ Edited ]

Unfortunately there is no benchmark for shapefile vs database.
From my experience, shapefile provider is faster from the same database.



Occasional Contributor
Posts: 18
Registered: ‎06-01-2016

Re: Apollo wms Shape vs SQL

THX Haiyan... I´m running some test and so far, it looks like shape file is faster than postgres on vector layer if there is a big number of features, for smaller datasets database works faster. I would be good to have official benchmarks and recommendations to optimize services.

Do you need immediate support?
If you encounter a critical issue and need immediate assistance please submit a Service Request through our Support Portal.