Benchmarking 2011/QGIS notes

Data

QGIS also requires tables with unique keys like Cadcorp GeognoSIS. Additionaly, QGIS doesn't support "order by" clauses for DB layers.

The views were converted to tables, and indexed, as follows:

CREATE TABLE osm_roads_ordered AS (SELECT * FROM osm_roads ORDER BY z_order ASC, st_length(geometry) ASC);
ALTER TABLE osm_roads_ordered ADD COLUMN unique_id serial;
CREATE INDEX osm_roads_ordered_geometry_sidx ON osm_roads_ordered USING gist(geometry);
INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
SELECT '', 'public', 'osm_roads_ordered', 'geometry', ST_CoordDim(geometry), ST_SRID(geometry), GeometryType(geometry)
FROM public.osm_roads_ordered LIMIT 1;
CREATE UNIQUE INDEX osm_roads_ordered_unqidx ON osm_roads_ordered(unique_id);

CREATE TABLE osm_roads_gen0_ordered AS (SELECT * FROM osm_roads_gen0 ORDER BY z_order ASC, st_length(geometry) ASC);
ALTER TABLE osm_roads_gen0_ordered ADD COLUMN unique_id serial;
CREATE INDEX osm_roads_gen0_ordered_geometry_sidx ON osm_roads_gen0_ordered USING gist(geometry);
INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
SELECT '', 'public', 'osm_roads_gen0_ordered', 'geometry', ST_CoordDim(geometry), ST_SRID(geometry), GeometryType(geometry)
FROM public.osm_roads_gen0_ordered LIMIT 1;
CREATE UNIQUE INDEX osm_roads_gen0_ordered_unqidx ON osm_roads_gen0_ordered(unique_id);

CREATE TABLE osm_roads_gen1_ordered AS (SELECT * FROM osm_roads_gen1 ORDER BY z_order ASC, st_length(geometry) ASC);
ALTER TABLE osm_roads_gen1_ordered ADD COLUMN unique_id serial;
CREATE INDEX osm_roads_gen1_ordered_geometry_sidx ON osm_roads_gen1_ordered USING gist(geometry);
INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
SELECT '', 'public', 'osm_roads_gen1_ordered', 'geometry', ST_CoordDim(geometry), ST_SRID(geometry), GeometryType(geometry)
FROM public.osm_roads_gen1_ordered LIMIT 1;
CREATE UNIQUE INDEX osm_roads_gen1_ordered_unqidx ON osm_roads_gen1_ordered(unique_id);

Raster

Create GDAL VRT from tile index:

/opt/qgisms/bin/gdalbuildvrt /benchmarking/wms/2011/data/raster/DEM/bil_16int/dem_bil16int.vrt /benchmarking/wms/2011/data/raster/DEM/bil_16int/dem_bil16int.shp