Questions tagged [performance]

Performance concerns how effectively a computing system uses resources.

Filter by
Sorted by
Tagged with
-1
votes
1answer
48 views

More Pythonic way to loop through UpdateCursor?

I have several sets of fields to populate based on other fields. The code below works, but I am wondering if there is a more Pythonic way to march through the i,j pairs? (Actual fieldnames are not ...
1
vote
1answer
287 views

Speed up intersection, union in PostGIS?

I have three tables: water, wetlands and parcels. I want to update parcel table with area that is covered by water or wetland (they can overlap). So I want to Merge water with wetland Dissolve and ...
2
votes
1answer
107 views

Optimizing workflow for FUSION's PolyClipData?

I have multiple large LiDAR datasets (.laz) from different areas, where I need to extract buildings. I have prepared a shapefile containing a buffer around the buildings I care about, and are using ...
0
votes
0answers
139 views

MS SQL Server STEnvelope() performance

Using MS SQL Server 2012, when we write a query with select GEOM.STEnvelope() from table where table holds approx. 4000 native SQL Server line geometries of type geometry, with 2/6/180 points min/...
0
votes
0answers
93 views

Does Geopackage field length affect performance?

I have moved away from shapefiles, and now store most of my desktop spatial data in a Geopackage. One of my fields is used to store research notes and is 'Type TEXT' with a character limit of 254. I ...
2
votes
0answers
122 views

pgrouting extension slow in PostgreSQL 10?

I am trying to implement routing on my road dataset using pgrouting function pgr_createTopology. It works fine on postgresql 9.6 but gets extremely slow and get stuck as nodes increase in postgresql ...
0
votes
1answer
257 views

Geoserver slow rendering un-cached layers

I have GeoServer connected to a SQL Server datastore. I have a map with 5 Layers, the layers have about 200,000 features total. The features are styled as simple points or lines - not many lines ...
2
votes
1answer
162 views

Leaflet GeoJSON Map Buffering

I am using Leaflet with Custom GeoJSON Layers to display my map. I noticed that the map off-screen is only loaded after releasing the mouse button during a drag. Hopefully, this demo makes it more ...
3
votes
0answers
40 views

Nesting styles for increased drawing speed

I have zoning plans for a municipalities ( for example 5700 features in this one) and I have created a QGIS-style to make it look like the offical style. There are 72 colours/patterns for the ...
1
vote
0answers
182 views

GeoServer GetMap with geopackage very slow (with high zoom levels)

I have a GeoServer instance and have imported multiple high res tiff files as layers and created a layergroup from the layers. When I call the WMS endpoint with a specified bbox and the geopackage ...
0
votes
0answers
41 views

Speeding up contouring of .mrr files in Mapinfo?

I'm contouring relatively small 30m resolution grids - 50-100mb .mrr files. Creating a simple 1 level contour takes hours! I let a slightly larger one run on a spare machine and it took days. Is ...
0
votes
2answers
40 views

Data Driven Pages Optimization for the same FC referenced twice

I have a feature class that I am referencing twice in my map, for "active" features that are "the subject" of the map page as a Feature Layer second Feature Layer that is grayed out/"inactive" on ...
4
votes
2answers
374 views

Healthy number of tables in PostgreSQL schema?

I manage a PostgreSQL + PostGIS database with two schemas of 200 and 120 tables. I wonder if this is correct or I should organize the tables in more and smaller schemas. So far, we hadn't had any ...
0
votes
0answers
46 views

Network Analyst takes so long

Is there some kind of limitations of number of features when we work with Network Analyst in SDE ? My net has 170.000 features, is it a problem ? Because it take at least 6 hours to finish the "Build ...
1
vote
1answer
94 views

Improving ArcMap Batch Production of PDF Maps Performance?

I am producing 1,500 PDF maps and was wondering what changes I can make to either my machine or to ArcMap to help speed things along. Currently, it takes 5:45 - 6 minutes to produce four maps. If I ...
1
vote
2answers
310 views

MySQL 8 MBRIntersects 10 times slower than PostGIS equivalent

I'm trying to migrate a PostGIS database to MySQL 8 and am having a big performance hit when it comes to MBRIntersects. Using Mapbox to render vector tiles, I need to extract geometry intersecting ...
0
votes
1answer
74 views

Openlayers ArcGIS image vs tile service performance

I want to show my ArcGIS REST MapServer image tiles on my OpenLayers 4 application. But there are two kind of examples to use ArcGIS MapServer. ImageLayer and ImageArcGISRest TileLayer and ...
0
votes
0answers
138 views

Performance issues in Carto-VL?

UPDATE: Issue will be solved in next version of Carto. See github I'm using Carto VL to build a simple webapp for some data inspection within our GIS team. The web-app can be found here (Link might ...
2
votes
0answers
129 views

Caching WFS requests using OpenLayers?

I'm investigating how we can improve our vector-layer performance of our GIS component (based on openlayers 4). OpenLayers keeps all the fetched vector features in memory. This becomes a problem ...
4
votes
1answer
462 views

Understanding Extract Multi Values to Points performance in ArcPy?

I am trying to extract points from multiple raster files into a points shapefile. I have about 320,000 unique XY coordinates which need to extracted values from 37 raster files. I tried running the ...
2
votes
2answers
500 views

Nearest Neighbor

We've got a table of approximately 300,000 points and would like to find the nearest neighbor (within 10km) to each point in the same table. The most efficient query we've found so far is below, but ...
0
votes
1answer
42 views

Xray extension slowing down Catalog

I recently installed Xray for Catalog and my Catalog has been insanely slow ever since. I've uninstalled the Xray extension but my Catalog is still slow. Any suggestions to speed Catalog back up to ...
0
votes
0answers
200 views

Labels are loading slowly in ArcMap?

I am trying to speed up the process of loading labels in ArcMap. There are few layers containing labels that have a conditional form (not only in content but also text formatting). According to Esri ...
0
votes
1answer
518 views

Fastest way to know in which section of line is a point

I have a line and a point. I want to locate where is this point in the line according to imaginary sections I make (any way I want). The output should be in which number of section is the point (...
1
vote
1answer
1k views

Fastest way to extract a raster in R (improve the time of my reproducible code)

I'm wondering if I have maximized the speed at which a mean of an area buffered around a point in a raster can be extracted. Fastest way I have ever found to extract a raster, with the pre-cropping ...
0
votes
1answer
185 views

Will using Zee Drive affect the performance of QGIS [closed]

At our company we are thinking of moving from a server to our local machines with Sharepoint. Zee drive would be implemented to act as an interface for all our files, including our geospatial data. ...
1
vote
0answers
54 views

Unable to get points in buffer on selected feature in QGIS using Python?

I have to create a 1.5 km buffer on each latitude/longitude of layer A. I would like to know how many points of line B will be inside the buffer of layer A. I used the following code but it takes too ...
1
vote
1answer
84 views

Reprojecting basemap layers in ArcMap without slowing down zoom and pan options?

I am using ArcGIS 10.5.1 on a high processing computer. I have 4768 data points that I am required to zoom into and pan around to determine their composition. They are projected in NAD 83 CSRS ...
4
votes
2answers
298 views

Measuring loading times in QGIS using PyQGIS?

Is it possible to measure when QGIS starts and stops loading/rendering a layer? I used something similar in OpenLayers before (loadstart and loadend event, http://dev.openlayers.org/examples/...
1
vote
1answer
466 views

PostGIS speed up query

I know this question (or a version of it) has probably been asked but I cannot seem to figure out a solution to my problem. The core spatial operation is finding which of my points are inside ...
1
vote
1answer
191 views

Join.Field_management extremely slow in arcpy stand-alone script

I have an arcpy script that joins two tables together based on the FID field. This slows down my script considerably. The joining process takes several tens of minutes. import arcpy import os from ...
1
vote
0answers
221 views

Investigating slow performance when opening tables in ArcGIS Desktop? [closed]

My ArcGIS 10.5 performance is very slow just in opening some thinks like: Options, tables, labels, arctoolbox, draw menu ect. It open the mentioned things in about 3 minutes. I have tried different ...
0
votes
0answers
67 views

Slow rendering of 25 MB raster in ArcScene

I am loading one raster layer that is 25 MB in size. It is a 1926x2042 1m DEM. I need to render it at a cell size of one for optimal display of the layer. When I open a saved .mxd with the only the ...
0
votes
0answers
470 views

Speeding-up processing of pair-wise distance calculation in Python?

I am trying to do a cluster analysis using DBSCAN for my time series NDVI image in Python. I am using distance time warping (DTW) to measure distances between my time series. With this, I am computing ...
1
vote
1answer
269 views

QGIS more than 3000 raster works slowly

I need to add to QGIS more than 3000 rasters tif (with pyramids). It works very hard and slowly. So I ask: There's a solution that give's them quickly?.
2
votes
0answers
476 views

Speeding up Raster to Polygon Conversion in ArcMap/arcpy

I am trying to convert a series of big binary rasters describing data in grey (value 0) and nodata in green (value 1) into polygons in order to derive the extent the data pixels are covering (see also ...
7
votes
2answers
187 views

Prevent SAGA in QGIS 3.0 from creating certain outputs?

I'm wondering if there is a way to prevent SAGA from generating temporary files. For example, if I just want to generate a slope map using SAGA I have to wait for all 11 other grids to get processed. ...
-1
votes
1answer
54 views

Speeding up sDNA analysis [closed]

I am trying to analyze several cities around the world (including major cities like London, Tokyo or Beijing) using different centrality measures with varying radiis. The problem with this is that ...
2
votes
0answers
184 views

QGIS virtual layer with SQL GROUP_CONCAT performance

I have a polygon shapefile layer, Property, with property ownership parcels and a SQLite database with projects. My goal is to highlight the parcels where an entry in the Projects database and show a ...
1
vote
2answers
60 views

Comparing Object Fields to a couple million rows with a SearchCursor from arcpy

I'm new to GIS. I'm using arcpy.da.SearchCursor to read from a SQL server, and when I read through the first table I create objects ~350,000 of them. cursor = arcpy.da.SearchCursor(...
0
votes
1answer
110 views

ArcGIS REST API test performance

I need to test the performance of the ArcGIS REST API (Version: 10.51) on the map services I have created. The tester within our team is using swagger but it is not implemented in the ArcGIS REST API. ...
1
vote
1answer
146 views

Finding nearest point for each distinct category in performant way using big PostGIS table?

I have a table, etablissements with millions of rows, and a geom (st_point) column , spatially indexed (using gist). Those features may have a different category, activite_principale. I want to find ...
1
vote
1answer
57 views

How much resources/performance is used by each additional projection available for a WMS service? [closed]

The service provider set up the GetCapabilities response for the WMS service. This defines which projections are supported by the WMS service and these are also the projections that can be requested. ...
6
votes
2answers
247 views

Geometry distance PostGIS query with <-> operator suddenly much slower

One of my websites suddenly got much slower, and I've managed to track down the issue to a query that uses the <-> operator together with ORDER BY (2D distance between two geometries) to ...
6
votes
1answer
137 views

PostGIS slow intersection

Yet another intersection issue. I'm working with OSM database in PostGIS. Now trying to count all buildings that fall into a countries bounding box. This is my query (bbox for Germany). SELECT ...
-1
votes
1answer
280 views

Does Spatial Index make feature class faster? [closed]

Does spatial index make dataset work faster? Are there any disadvantages in having it? All datasets in my sde don't have a spatial index. I thought I should add it to make things faster
1
vote
1answer
47 views

Carto Builder Azure Marketplace - default Postgres configuration causing poor performance

We recently learned some valuable lessons which I wanted to share with the community. We recently moved our map application from being hosted by CartoDB onto an Azure Marketplace Carto Builder VM. ...
4
votes
1answer
262 views

Importing CSV (via VRT) to PostGIS is slow with -skipfailures?

I am importing about 60 million records of csv data (about 25gb) to Postgresql server using ogr2ogr After googling million times, I found out that I can make VRT file and uploading my csv file using ...
5
votes
0answers
275 views

When should I use gdal_merge.py?

When building a single georeferenced image from a collection of tiles, gdalbuildvrt followed by gdal_translate is much faster than gdal_merge.py. In my own measurements of gdal_merge.py \ --...
2
votes
1answer
232 views

Multiple Ring Buffer performance issues

I just computed multiple ring buffers for a point in EPSG 4326 with a 100m interval for a maximum distance of 1000m. I was observing a calculation time of approximately: 50s within ArcMap; 4min in ...