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.
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
On Wed, Sep 29, 2010 at 9:25 PM, Bino Oetomo <[email protected]>wrote:
> Dear All.
>
> I've a long rendering time problem.
>
> Here is my setup condition.
> 1. Server : Postgis and tomcat at the same box, 1Gbyte RAM
>
> 2. Data :
> 2.a The Total data is about 380434 rows (estimated by PgAdmin)
> 2.b data is splited into 5 different views, based on "level" coloumn value.
>
> 3. Layer :
> 3.a I created 1 layer for each pgsql view
> 3.b Specific sld for each layer
> 3.c Each sld have up to 4 rules, based on Scaledenominator.
>
> 4. Map display box :
> 4.a width: 512px;
> 4.b height: 512px;
> 4.c border: 1px solid #ccc
>
> 5. HTML:
> My HTML is jus displaying Googlemap (ROADMAP) , plus 5 layer created in
> step#3
> There is -->
> var options = {
> projection: new OpenLayers.Projection("EPSG:900913"),
> displayProjection: new
> OpenLayers.Projection("EPSG:4326"),
> units: "m",
> numZoomLevels: 20,
> maxResolution: 156543.0339,
> maxExtent: new OpenLayers.Bounds(10325843.277142,
> -1394213.708171, 16871298.882086, 1110474.834229)
> };
> ===============
> And at the end part -->
> var point = new OpenLayers.LonLat(110.3667, -7.8000);
> // Need to convert zoom point to mercator too
> point.transform(new OpenLayers.Projection("EPSG:4326"),
> map.getProjectionObject());
>
> map.setCenter(point, 19);
> =================
>
> Before I load the html, I open a terminal at the server and do :
> ---> b...@erp:/var/lib/tomcat6/webapps/geoserver/data/logs$ tail -n0 -f
> geoserver.log |grep "done"
> Back to my firefox and load the html
> The Googlemap loading is fast enough (For me), but the WMS rendering
> part is so long.
> Back to the terminal and Copy paste the terminal output , and voila .....
>
> 6.a there is 210 time of "Writing png image", and
> 6.b Verry long time :
> First writing is at :
> 6.b.1 2010-09-30 09:23:11,289 DEBUG
> [org.vfny.geoserver.wms.responses.map.png] - Writing png image ... done!
> Last Writing is at :
> 6.b.2 2010-09-30 09:31:08,168 DEBUG
> [org.vfny.geoserver.wms.responses.map.png] - Writing png image ... done!
> Note : The Complete output of the "grep" process is posted at
> http://pastebin.com/nxXrXBDh
>
> With all the process , it only need to display one-object of Postgis
> It's showed at http://i54.tinypic.com/qxkynp.png , the bold text under
> the cursor ... it's a label of the only point that need to be displayed
> by the HTML.
>
> Question : Is it normal that this operation take almost 8 minute
> processing time ?
> Did I do something wrong ?
>
> Kindly please give me your enlightment
>
> Sincerely
> -bino-
>
>
> ------------------------------------------------------------------------------
> 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
>
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
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
