I am exporting a large dataset from PostGIS to GeoPackage and then trying to use it in QGIS and ArcMap. The GeoPackage size is 17Gb and contains around 6 different tables. The biggest table contains around 200million linestring features.
I have created the GeoPackage using ogr2ogr 2.1.3 which automatically adds a spatial index and am using QGIS 2.16.3 and ArcMap 10.4.
When I try and open the GeoPackage in QGIS it takes well over two hours before QGIS becomes responsive and starts to render the features at which point I can add a stylesheet or restrict the zoom ranges.
How can I use this GeoPackage more efficiently?
Do I need to VACUUM ANALYZE it like I would in PostGIS?
Or do I need to somehow add the stylesheet to the GeoPackage to restrict showing features at to high zoom levels.
Extra Details: Windows Server 2012 64Bit 16Gb RAM