Hi.
I have a question, the last week i was publishing with geoserver one WMS
service, based in one and only vector layer in geopackage (gpkg), With
geoserver 2.1.12 plugin .
I was generate the GPKG file previous with two options: QGIS 2.18, and when
export i was select the option (create spatial index).
Another form to creating the geopackage with ogr2ogr, not with QGIs, And I
verify that it has spatial index.
With both the same results in geoserver wms publish.
After publishing the wms service, I was founding that the request getmap in
geoserver for wms returns the png image slowly, a lot of time for response
(5 minutes). Compared with other wms based in shapefile (1 minute), (whith
the same shapefile i was creating the gpkg), the wms service based in
shapefile returns the png (getmap) image with 80% less time.
The geopackage file that i use is nearly to 1Gb, more than one million
lines, and has spatial index. The shapefile is 500 mb more greater than the
gpkg. At my desktop station (imac pro 2017-64gb ram) render fine in qgis
2.18, with times to render more or less equal. (2 minutes), for shapefile
and gpkg file.
my server has 100Gb Ram, xeon processors, is a good machine in theory for
this task, and i prepare geoserver 2.12 for production.
My question is:
geoserver 2.12.1 with the extension geopackage support the spatial index
(geopackage) how mechanism for optimizing access to data??
In theory for me the request getmap for the wms service (layer gpkg) in
format PNG should recover more faster the results, or nearly to the time
reponse for wms based in the shapefile layer.
Thank u.
------------------------------------------------------------------------------
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
