Justin ... You ARE rights !!! Justin Deoliveira wrote: > My first guess would be the database not being properly indexed. > Ensure that you have spatial indexes on every geometry column involved > in the query. Also when using SLD's with complex rule based styling it > is also important to index any non geometric attributes involved in a > PropertyName of a filter. > I do what you suggest and the result is : 1. Number of writing is still 210 times .. BUT 2. The rendering time is only 5,324 seconds 2.a First ---> 2010-10-01 09:06:23,757 DEBUG [org.vfny.geoserver.wms.responses.map.png] - Writing png image ... done! 2.b Last ---> 2010-10-01 09:06:29,081 DEBUG [org.vfny.geoserver.wms.responses.map.png] - Writing png image ... done! (note : my server use "," as decimal)
I really appreciate your enlightment Sincerely -bino- > What I would do is turn up GEOTOOLS_DEVELOPER logging in geoserver to > see the actual sql statement that gets generated for the map request. > Then take that query and do an explain on it in the database to see if > an indexed lookup is properly occurring. If not the issue is probably > there. If it is you can nail it down to something else in geoserver. > > -Justin > ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
