[postgis-users] Re: [postgis-users] Re: Postgis too slow

[Obe, Regina DND\MIS]

I don't know if these have been answered before

1) But what kind of box is your mapserver and postgis running on? (e.g
processor and memory) - I assume its the same box since you don't have a
host line in there.

2) Are you using the latest libpq on your webserver?
3) For a general street search query - how many tuples are returned? 
4) What is the general image size in kilobytes (of the rendered image)
5) Without the postgis layer (just doing panning and zooming etc.) - I
assume the speed is decent?

-----Original Message-----
From: shpr at libero.it [mailto:shpr at libero.it]
Sent: Wednesday, May 22, 2002 12:47 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Re: [postgis-users] Re: Postgis too slow


Excuse me, here there is the right map file

> Sorry... I meant to say "mapfile" not "shapefile"...
> Chris
> 
> Chris Hodgson wrote:
> 
> > Did you send the wrong shapefile? There is no reference in there to 
a postgis layer...
> >
> > Chris
> >
> > "shpr at libero.it" wrote:
> >
> > > ok, here there are the db schema and the .map file.
> > >
> > > The street table have about 800000 tuples.
> > >
> > > Thanks for your help!
> > >
> > > Stefano
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>