[postgis-users] mapserver db connection

[Gregory S. Williamson]

Frances --

Have you tried running the same queries in postgres natively -- it may be that postgres is not giving you all that it can, especially if this is an "out-of-the-box" installation, which is set to allow low end machines to run, but definitely is not tuned for performance in terms of memory settings and the like.

Also, are the tables indexed and recently analyzed/had geometry stats done on them ?

Connecting to postgres can be relatively slow -- I think the fastCGI variant of MMS may handle this better.

And of course, it *could* be inherent in MMS -- I have read that on this list that shape files are faster for some purposes.

HTH,

Greg Williamson
DBA
GlobeXplorer LLC
-----Original Message-----
From:	postgis-users-bounces at postgis.refractions.net on behalf of Frances Collier
Sent:	Mon 10/24/2005 1:29 PM
To:	postgis-users at postgis.refractions.net
Cc:	
Subject:	[postgis-users] mapserver db connection
Hello,

 

I've been trying to find out what exactly Mapserver gets back from Postgis
when querying the tables. I haven't found this to be documented anywhere.
Does Postgis return a shape file, layer, or simply data rows? The reason I'm
asking is that I noticed a huge time difference between connecting to
Postgis and simply calling the shape files - with the Postgis being
significantly slower. I know Postgis offers a lot more functionality, but
for simple comparisons I do not have any type of filter applied.

 

I'd appreciate any knowledge, advice, and/or direction.

 

Thank you,

Frances Collier