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 _______________________________________________ Cartoweb-users mailing list Cartoweb-users@lists.maptools.org http://lists.maptools.org/mailman/listinfo/cartoweb-users
