[Cartoweb-users] Cartoweb 3.4.0 slow and stuck

[Yves Jacolin]

Le samedi 28 juillet 2007 14:41, Volkmar Herbst a écrit :
> Dear all, I have a serious problem with a site where the performance is
> very slow. Especially when the user zooms in, it takes ages to created
> display the image and sometimes it gets stuck completely. I checked the
> processes (Windows2003 server 2 processor 3,4 GHZ, 6 GB RAM) but it seams
> that resources are not a problem. I configured the application but did not
> add or change any of the php or java code. I use postgis data and have to
> display about 12 layers of which the largest has 60 000 features. That
> should go much faster.
>
> I also checked the cache options (an of course profile production) but no
> result. I checked with shapefile (thought that it might be the postgis
> configuration) but it was only slightly better,.
>
> Does anybody have any ideas what else I could try???
>
> Or anybody experienced the same problem???
>
> Thanks for any hints
>
> Volkmar
Hi volkmar,

did you try to create spatial index for your postgis data?

CREATE INDEX [Index_name ON [table_name
  USING GIST ( [geom_field] GIST_GEOMETRY_OPS ); 

e.g. 

CREATE INDEX index_road_geom ON road USING GIST (the_geom);

Regards,

Y.
-- 
Yves Jacolin
-------------
http://yjacolin.gloobe.org
http://softlibre.gloobe.org