[postgis-users] Postgis performance

[Webb Sprague]

Hi Ibrahim

Oh -- you need to read the docs on postgis (NOT mapserver) here:

http://postgis.refractions.net/docs/

You will index the geometries within the DATABASE, probably from an SQL prompt.

Mapserver is another layer altogether that calls the geo database but
doesn't manipulate it.

Does that help / make sense?

On 4/16/07, Ibrahim Khachab <ibrahim at oriented.it> wrote:
> Webb Sprague ha scritto:
>  > Hi Ibrahim
>  >
>  >> The same maps  with the shp file are 10 times faster than those with the
>  >> Postgis data.
>  >> What can be the problem.
>  >
>  > Have you indexed the geometries?
>  >
>  > Please send samples of specific data, queries, results and
>  > performances to the list.
>  >
>
>
> Hi Webb,
>
> What do you mean by
>  > Have you indexed the geometries?
> Is there a guide about index creating for the geometries?
>
> I'm making a little test using a php script that you will find here below.
> I will include the two map file I use to make the test (one with the
> shape files and the othe with the postgis.
>
> Thank you in advance.
> Ibrahim
>
>
>
>
> *************   PHP FILE    ***************
<SNIP>