If both the database query and the rendering step inside GeoServer are
taking a long time, that suggests to me that you are simply fetching and
processing a lot of data. Do you have an idea of how many features are in
the tiles that are slow to render? Are tiles at larger scales (covering
less space hopefully implies covering fewer features) faster to render?
On Mon, Oct 14, 2013 at 8:28 AM, Jonathan Moules <
[email protected]> wrote:
> Hi List,
> I'm having issues with tile rendering speeds for my basemap. It's taking
> up to 45 seconds to return a non-cached tile.
> The data is coming from some Oracle tables (spatially indexed; plus the
> filter attribute is indexed too) and there's a fairly complex series of
> SLD's behind it.
>
> Test results for a single tile below. In the attached zip is an
> over-compressed JPG version for the list; but the outputs are PNGs (this
> one is about 100KB).
>
> I did three tests in this order for the same tile from different GeoServer
> instances (but all calling the same database).
> 2.4.0-Test - 17 seconds
> 2.3.5-internal - 5 seconds
> 2.3.5-external - 6.8s
>
> As you can see it got faster once Oracle figured out what was going on.
> But it was still very slow.
>
> Also in the zip is the GeoTools level logs. It's clear most of the delay
> is Oracle, but the tile rendering is also quite slow taking over a second
> in all instances if I'm reading this right.
>
> I also tried it with a older, slightly simpler style but got similar times:
> 2.3.5-external - 6seconds
> 2.3.5-internal - 3.8seconds
> 2.4.0-Test - 9seconds
>
> I'll try the new PNG encoder, but that isn't likely to help with the
> fundamental issue.
> Can anyone suggest why things (including the oracle) are so slow? It used
> to be faster.
>
> Many Thanks,
> Jonathan
>
> This transmission is intended for the named addressee(s) only and may
> contain sensitive or protectively marked material up to RESTRICTED and
> should be handled accordingly. Unless you are the named addressee (or
> authorised to receive it for the addressee) you may not copy or use it, or
> disclose it to anyone else. If you have received this transmission in error
> please notify the sender immediately. All email traffic sent to or from us,
> including without limitation all GCSX traffic, may be subject to recording
> and/or monitoring in accordance with relevant legislation.
>
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
> from
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60134071&iu=/4140/ostg.clktrk
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
--
David Winslow
Boundless - http://boundlessgeo.com/
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60134071&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
