[postgis-users] mapserver db connection
Gregory S. Williamson
gsw at globexplorer.com
Mon Oct 24 14:02:57 PDT 2005
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.
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
Subject: [postgis-users] mapserver db connection
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.
More information about the postgis-users