[Cartoweb-users] Cartoweb 3.4.0 slow and stuck
yjacolin at free.fr
Sat Jul 28 08:49:40 EDT 2007
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
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 );
CREATE INDEX index_road_geom ON road USING GIST (the_geom);
More information about the Cartoweb-users