Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [performance]

Performance concerns how effectively a computing system uses resources.

0
votes
1answer
52 views

Which is more performant GeoJSON or WMS/WFS using OpenLayers? [on hold]

I'm developing a web application using PostGIS, Laravel, Vue.js and Openlayers, for the moment I generate the GeoJSON from my database using the following code : public function plosWithGeom() { ...
1
vote
0answers
19 views

Creating IDW of up to 20,000 points in ArcGIS Desktop? [on hold]

I am create IDW interpolation of 60-70 points in ArcGIS. It takes 2 minutes. But when I create IDW of 20000 points in ArcGIS, it takes at least 4 hours and 30 minutes. I want to ask why takes much ...
1
vote
1answer
51 views

Improve render speed for QGIS canvas (hardware)

I'm using QGIS to build complex maps from OSM-Data (GPKG or PostGIS). I'm wondering, how I should upgrade my system, to speed up rendering in canvas: Intel I5 4x3,2GHz, 16GB DDR3, SSD Or what about ...
1
vote
0answers
39 views

Changing CRS of geometry in geopandas dataframe efficiently?

I have a shapefile which I am converting into a geopandas dataframe. The CRS of this shapefile is epsg:4326 and I want to convert this to epsg:3857. import geopandas as gp file_path = 'zip_poly.shp' ...
11
votes
1answer
101 views

Python Script Performance as an ArcGIS Tool Versus Stand-Alone

Has anyone studied the difference in running a Python script in ArcToolbox versus as a stand-alone script? I had to write a quick-and-dirty script to convert a set of RGB images to single band by ...
1
vote
0answers
52 views

Making ArcPy script quicker? [closed]

The script below is used to update a shp which is missing values from another .shp using a spatial reference. It's taking about 19 minutes to run through ~53,000 rows. Any ideas on how I can make it ...
0
votes
0answers
12 views

Prevent slowing of story map from large data?

I have a building layer that has about 9k polygons and it's slowing my story map. I've tried simplifying the polygon as much as possible, but no luck. Has anyone figured out a method to work with ...
3
votes
1answer
70 views

Spatial Index on 100s of Millions of Records Taking Days in PostGIS? [closed]

I have a table with ~200million spatial records in it, and it is taking days to build a spatial index on the one geometry column: should this be taking so long? The geom column is of the type ...
1
vote
1answer
50 views

Does power of GPU affect performance of analyses by ArcGIS Desktop? [closed]

Does the power of GPU affect the performance of analyses such as Segment Mean Shift, conversion to/from raster, etc? Is the GPU used only for caching GUI elements to give a smoother user interface ...
0
votes
0answers
11 views

Android laggy map after adding vector objects

I'm using GLMap to render over 5000 vector objects in an Android Application. Here is the framework I'm using: https://getyourmap.com/ Currently, I have Shapefiles which I convert with https://...
0
votes
0answers
31 views

Finding and fixing source of repeated seed.TruncateTask for empty string errors using GeoServer and GeoWebCache?

Googling this issue is getting me nowhere so I thought I'd cast a wide net here in the hope of getting an actionable lead on this. Our GeoServer instance is configured for GeoWebCache. While ...
1
vote
1answer
26 views

Downloading or caching web based map service for faster access?

The Western Australia Department of Mine and Petroleum allows access to one of their online systems called Tengraph Web with which I can view tenements, major infrastructure, and topography for the ...
1
vote
1answer
57 views

Is Geometry object intersect faster than Intersect_analysis in ArcPy?

I have a script attempting to identify Many-to-Many matches between two different parcel layers. It is an iterative process, during which I dissolve the selected polygons in layers A and B, intersect ...
0
votes
1answer
57 views

Distance between coordinates computation speed: conversion to UTM vs Great Circle

For a program I am writing I need to calculate the distances between coordinates. Seeing as I need to perform a large number of these calculations for each coordinate (thousands) it makes sense to ...
3
votes
1answer
76 views

QGIS 2.18: Speed up QgsFeatureRequest in Python Script

I have two input layers. The first one is a line-layer named "graph" and the second one is a point-layer named "nodes". The "graph"-layer: The graph layer holds 177350 line features which are ...
0
votes
0answers
161 views

Leaflet Mobile Performance (A Couple of Polygons)

I wrote a small Angular app with leaflet.js. In desktop browser scrolling and dragging speed is good but on mobile browser, performance is painfully. There are 8 polygon and 129 circle marker on the ...
0
votes
0answers
22 views

ArcGIS Modelbuilder model clogs up memory?

I have a model in which a zonal histogram is computed of each line in a feature class, showing the amount of cells each line intersects in a raster file. After this, this column is joined to a table ...
0
votes
1answer
129 views

Calculating euclidian distance in R between lines and points?

I have a large SpatialLinesDataFrame "o" (~500,000 roads) and ~3000 survey points "r", I'd like to calculate the distance to the nearest line for each survey point and extract relevant columns. My ...
2
votes
1answer
196 views

QGIS very slow when browsing files on macOS

QGIS is performing very slowly for me when browsing files and folders recently. I am running macOS Mojave and have no performance issues within QGIS, apart from the times I need to open or save a file....
3
votes
0answers
31 views

Testing a GeoServer “Scrolling” performance

I'm looking for a way to test the responsiveness of various layers when scrolling around the map. So after a layer is loaded and the user is moving around the map looking a specific area or whatever. ...
3
votes
2answers
92 views

Script I made for pyQgis runs slow but can't find another way around it

registry = QgsProject.instance() first_layer = registry.mapLayersByName('buffered')[0] second_layer = registry.mapLayersByName('buffered')[0] areas = [] instrument_number = "tin_ttl_in" proprietor =...
1
vote
0answers
44 views

Controlling CityGML performance?

I tried to convert single LOD3 building using FME. I am able to convert successfully from DGN to cityGML format.But when I tried to view the same in FZKViewer/FME data inspector the performance is ...
3
votes
2answers
64 views

Running arcpy.AlterField_management 2,000 times takes too long?

I am trying to replace field names of a table stored in a file geodatabase using a dictionary as a lookup table. My field names got cut off from the Tabulate Area tool (Tabulate Area Truncates Field ...
0
votes
0answers
34 views

AddRastersToMosaicDataset_management performs slow

I have an enterprise Geodatabase (SQL Server) on my ArcGIS server machine. I perform my computations on several rasters on another machine (80 *.tif s with mean size of 50kb). When I want to add the ...
1
vote
0answers
170 views

Comparing speed of Spatial Analysis with GeoJSON versus shapefile in QGIS?

I have a large dataset that I want to perform spatial analysis on in QGIS. Specifically, I want to perform a polygon intersection analysis between two polygon layers. Given the size of the dataset ...
4
votes
1answer
226 views

PostGIS ST_Intersects is slow and doesn't seem to use spatial index

There are several threads about ST_Intersects being slow (like this one). Main advise is to use spatial index. Well I know that and created spatial index beforehand, but the query is slow nevertheless ...
1
vote
1answer
91 views

Network Has Slow Performance in SDE

I am working with ArcGIS Network Analyst (10.5.1). I created a network in SDE and everything worked fine. The network is versioned on SDE. I updated the source line features of the network in a ...
2
votes
0answers
174 views

Optimizing MySQL query to select all points with in a large polygon using spatial indexes

Re-posting it from stackoverflow as per their suggestion. Link to the thread in stackoverflow https://stackoverflow.com/questions/53182385/optimizing-mysql-query-to-select-all-points-with-in-polygon-...
6
votes
1answer
266 views

Only union/dissolve intersecting features to save time?

I have one table of about 300k polygons, some overlapping but most do not. I need to dissolve the overlapping ones and also keep the non-overlapping ones. I only need the geometries, no attributes. I ...
1
vote
0answers
114 views

QGIS export selection to shapefiles is extremely slow; using only 5 to 10% CPU

I am using QGIS 3.2.3. I am trying to do some simple actions. Selecting by attribute and exporting to shapefiles. I am using a OSM file as a source which is barely 60MB. But for some reason the ...
2
votes
1answer
89 views

Speeding up ST_Value in PostgreSQL?

I am working on a large point file and am looking to get the raster value underneath each point. I am using: UPDATE Locations a SET image3b3_sum = ST_Value(rast, 1, geom) FROM image_sum_sum; 10 ...
5
votes
3answers
237 views

Which ArcGIS Online basemap has the best performance in ArcMap?

My company plans to do demos of ArcMap Add-Ins for some of our clients and we want to make sure ArcMap is performing the best it can. One of the major performance concerns is the speed of the ...
2
votes
1answer
51 views

ArcPy runs slow outside ArcMap?

I'm running a fairly small script to get height differences. The scripts gets the height in a point based on a DTM. Running the script in the ArcMap python window uses 1 min 30 seconds for 1000 points,...
1
vote
0answers
421 views

QGIS 3.4.0 Madeira: unresponsive

I "upgraded" from 3.2.3 to 3.4.0 and it's so unresponsive it's unusable. The startup time is the same as 3.2.3, then it needs half a minute to build its UI. When I click on the UI, the reaction is ...
-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
165 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
85 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
83 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
57 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
97 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
159 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
93 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
38 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
142 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
39 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
39 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
311 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
39 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
80 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
1answer
245 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 ...