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.