Shapefile vs. DB connections

[Ethan Alpert]

Using the shptree utility with Mapserver 4.4 shapefiles start to perform
pretty well in my tests using mapserver's queryByShape layer method.
There are many different facets to performance that depend on the data
(ie how geographicly dispersed it is, how high the vertice count is per
record and the size and number of attributes in the dbf file).

-e

-----Original Message-----
From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On
Behalf Of Paul Ramsey
Sent: Wednesday, June 22, 2005 10:08 AM
To: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: Re: [UMN_MAPSERVER-USERS] Shapefile vs. DB connections


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