Shapefile vs. DB connections

[Paul Ramsey]

No, we only did SDE, and a couple of Shapefile tests. But we could 
repurpose the test data and test harness for a Shape/PostGIS test.

Jeff McKenna wrote:

> I wonder if Brock Anderson looked at that as part of his MapServer vs 
> ArcIMS comparison.  I know he was specifically looking at SDE, but i am 
> just curious if he ran any postgis tests, because i remember from one of 
> his MUM3 slides that he had shapefile numbers.
> 
> jeff
> 
> 
> Paul Ramsey wrote:
> 
>> That is the conventional wisdom, and I have repeated it myself many 
>> times (on the basis of tests we did four years ago), but John 
>> Hagstrand has anecdotally told me that under concurrent load he finds 
>> his PostGIS is faster. So I think some new benchmarking is in order.
>>
>> Paul
>>
>> Kralidis,Tom [Burlington] wrote:
>>
>>> Hi,
>>>
>>> Does anyone have any info on comparing performance between serving
>>> MapServer w/ shapefiles vs. DB (i.e. PostGIS)?  I'm guessing shapefiles
>>> are quicker.
>>>
>>> Thanks
>>>
>>> ..Tom
>>
>>
>>
> 
>