Hi Paul,
It depends how large your datasets are. I know there are plenty of
instances of GeoServer being fed by an Oracle DB with millions of
features; Warwickshire's implementation has MasterMap features for a
large chunk of the urban midlands, there are around 30 million vector
features between the 6 topography layers and it works quite well, albeit
with a little bit of clever pre-tiling to help things along. There
should be no need to split datasets.
I'm guessing your addresses for the entire country is the
AddressBase Premium product. In that case you should only have a few
million features depending on how you loaded it. Have you joined it all
together in a single table, a materialised view, or a regular view? The
later will have abysmal performance no mater what you do.
Your email isn't clear on what your system is having the problems
with. Can you give us more details.
Things to bear in mind:
- Do you have spatial indexes?
- Do you have indexes on other columns that you're using for
queries. In ABP it may be one (or several) of the various address
columns for WFS GetFeature queries.
- Does it work if you use a simple style for rendering rather than
something complicated?
There are a number of other things you can do to optimise your
GeoServer install.
Simon's answer here may be helpful:
http://gis.stackexchange.com/questions/157287/how-to-optimise-rendering-of-layer-groups-in-geoserver
And this part of the docs:
http://docs.geoserver.org/stable/en/user/production/index.html
Cheers,
Jonathan
On 19/01/2016 08:01, Paul Wittle wrote:
Hi,
We have been finding that GeoServer struggles to render large datasets
from our Oracle database but we were wondering if there are known
levels at which you ought to split datasets for GeoServer?
I have seen plenty of information regarding Raster data and when this
is considered 'big data' but I have not seen much documentation on
vector datasets from spatial databases.
To give an idea of the scale, we are talking about addresses for a
whole country at the moment but I'm sure there may be any number of
datasets and factors. To give another example, would the limit on
complex polygons differ from simple points?
Would be great to hear some views or read some linked articles.
Thanks,
Paul Wittle
"This e-mail is intended for the named addressee(s) only and may
contain information about individuals or other sensitive information
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 email
in error, kindly disregard the content of the message and notify the
sender immediately. Please be aware that all email may be subject to
recording and/or monitoring in accordance with relevant legislation."
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
