PostgreSQL/PostGIS will run on Windows and Linux (I have it running on Windows
7/10 and some Windows Servers).
If you push the data to PostgreSQL/PostGIS, then you can develop some SQL
scripts that can take some form of constraint, i.e. Date/time, Feature ID,
bounding box, etc., and run an export/import from the main database server to
the “client” machines.
You will still have to ensure the client machines are setup correctly for
workspaces/stores/layers and styles.
If you are copying complete source from master server to clients, then a DB
backup/DB Restore should work fine. Just have to ensure the client data store
configuration gets updated.
Chris Snider
Senior Software Engineer
[cid:image001.png@01D2E6A5.9104F820]
From: Tripple Tee <tripplete...@gmail.com>
Sent: Wednesday, August 08, 2018 10:51 PM
To: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] CPU drain
Shape file is not doing well even on a powerful CPU. I have the same set of
data on a proper server with Xeon chip (Virtual Windows 2016 with 10 vCPU) the
performance is a mark improvement compare with the poor Celeron. The CPU usage
jump to 15% every time I zoom in or pan, but it still take a second to render.
I did some googling on Java and multi core/thread CPU. Seem like Java and most
software can not take full advantage of the multi core/thread provided by
hardware.
Thanks Brad for the info about PostGIS, I might have to stuck with shape file
and it lean, my design goal is portable:
1 geoserver on main server, when a team going away, all user need to do is to
robocopy the whole folder from the main server to the portable server. Lucky
GeoServer was written in Java so I can achieve this while using different OS
(main server is Windows 2016, portable server is Linux)
Might be able to do this with PostGIS but I will have to copy the database from
Windows to Linux, but it will not be a simple process for user.
Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10
From: br...@frogmouth.net<mailto:br...@frogmouth.net>
Sent: Thursday, 9 August 2018 11:43 AM
To: 'Tripple Tee'<mailto:tripplete...@gmail.com>;
geoserver-users@lists.sourceforge.net<mailto:geoserver-users@lists.sourceforge.net>
Subject: RE: [Geoserver-users] CPU drain
There are a bunch of tips at
http://docs.geoserver.org/latest/en/user/production/index.html and you need to
benchmark (e.g. with jmeter) against your expected workload when performance
tuning.
In general, shapefile is not going to be very high performance, as noted at
http://docs.geoserver.org/latest/en/user/production/data.html#use-a-spatial-database
Brad
From: Tripple Tee <tripplete...@gmail.com<mailto:tripplete...@gmail.com>>
Sent: Thursday, 9 August 2018 11:16 AM
To:
geoserver-users@lists.sourceforge.net<mailto:geoserver-users@lists.sourceforge.net>
Subject: [Geoserver-users] CPU drain
Hi,
Please give some pointer on optimising for better resource consumption
I am running GeoServer on Linux with Intel Celeron 4-core processor, which I
know is slow
When I open an individual layer (or layer group) of a region 200km each way
(with details like roads, buildings ...) the shape files size is under 0.5MB it
loads quite comfortably, effortless to zoom and pan.
When I open a layer (or layer group) of the whole world with less detail (only
land and water lines) it seem to struggle. The size of the shape file is around
5-7MB, I can see the CPU spike and it takes seconds to render as I zoom in or
pan the map. Note: I am preview this layer on the default 750x400 resolution
box. Should GeoServer only query data of the sub region for that preview box ?
1 - Is this the expected performance ?
2 – How can I optimize it to stop the CPU spike and lag,
Thanks
Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users