# Difference between revisions of "Benchmarking 2011/QGIS notes"

Jump to navigation
Jump to search

(JMeter) |
|||

Line 53: | Line 53: | ||

</pre> | </pre> | ||

− | [[Category:FOSS4G2011 | + | [[Category:FOSS4G2011]] |

## Latest revision as of 03:16, 24 February 2015

## 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

### JMeter

Running JMeter on JMeter server:

cd /opt/scripts/2011/jmeter/qgis /home/jmeterusr/jakarta-jmeter-2.5/bin/jmeter --nongui -t qgis-vector-3857-pg.jmx cd results ./process