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

Reply via email to