Questions tagged [performance]

Performance concerns how effectively a computing system uses resources.

Filter by
Sorted by
Tagged with
3
votes
0answers
36 views

QGIS form performance

I am using a QGIS 3.10.3 (but also tested with QGIS 3.4) directly connected to a PostgreSQL 11 with PostGIS. I am building a project and data model on which our data operators can do asset management....
1
vote
0answers
45 views

Using QGIS field calculator expression on Execute SQL

The following expression copy only minimum value from group/subset to a new column field in QGIS. Case when "FID_Net"=minimum("class", "FID_Net") Then "FID_Net" Else 0 End But this expression on ...
2
votes
1answer
106 views

Accelerating GeoPandas for selecting points inside polygon

I have one dataset with about 10 million points (lat, long). I would like to select the points that fall within a map. I have this map as a shapely object (.shp). To do this, I transformed the ...
1
vote
2answers
83 views

Layer from PostGIS view with dissolve slower than without in GeoServer

I created a view of a table containing line segments, where many lines may be part of the same project (and not necessarily adjacent) in PostgresSQL/PostGIS. The segments are joined to another table ...
4
votes
1answer
82 views

Optimizing Intersection Area Loops on big layers using PyQGIS

Using 3.10.1-A Coruña on Windows 10 I am looping over some (10) national shapefiles and finding intersection and areas but the process is very slow. I have two loops - one loop for each postcode and ...
0
votes
0answers
26 views

Getting SQL explain-plan for ArcGIS Map service

My organization has an ArcGIS map service that contains registered views from an Oracle 18c/10.7.1 geodatabse. I'm having some performance issues with the layers/views in the map service. I want to ...
1
vote
1answer
66 views

Expedite Near function in ArcMap 10.7 for 10^9+ coordinates?

I want to find the geodesic distance between the closest hydrography feature to each of my lat/long coordinates. I have hydrography data from New York state in a shapefile. I have many points, 10^10 ...
0
votes
1answer
20 views

GZIP geojson files & Mapbox GL JS

Is there a way to serve mapbox GL gzipped geojson files? I have style.json file that pulls multiple geojson files and it is pretty heavy.
0
votes
1answer
51 views

How to profile rendering performance using QGIS 3.10.x or above?

I am looking to be able to profile the rendering performance of a map and/or its individual component layers using QGIS. The metrics I am most interested in are: Access time Storage IOPS Storage time ...
4
votes
1answer
140 views

QGIS incredibly slow when trying to update large tables?

My point postgresql table has about 500k rows and about 20 columns People have about 5 fields that they update, the other fields are static Selecting the points is fairly instant, however using the ...
1
vote
0answers
75 views

Method selectedFeatures() works too slow in QGIS 3 Python console

I loaded spatial table(about 100 millions rows) from PostgreSQL(PostGIS) in QGIS3 and use method selectedFeatures() in QGIS 3 Python console. For such big tables it work very slow (it takes up to 10 ...
1
vote
1answer
43 views

Speeding up PostgreSQL UPDATE query?

I have a query running as below: UPDATE datasets.riverside_houses SET easting = addressbase.x_coordinate FROM datasets.addressbase WHERE addressbase.building_number = riverside_houses.house_number OR ...
6
votes
1answer
137 views

ArcPy UpdateCursor auto pausing after every 1000 records

I have an update cursor running that updates a field based on a lookup table (Python dictionary). The cursor completes fine, but seems to pause and hold after each 1000 records - I have a test in it ...
0
votes
0answers
21 views

Bulk modifying field alias names in file geodatabase [duplicate]

I am currently running large batches of modifying field alias names in a single file geodatabase. I am using ArcPy (ArcMap 10.7) AlterField_management function but it is too slow as it runs one at a ...
0
votes
0answers
91 views

OpenLayers performance issues adding features to vector layers

I have a fairly standard looking setup (standard in my eyes) but my performance is dreadful. My issue is that any fix stands me up for a fairly large reactor so I was hoping to get some advice. I ...
0
votes
0answers
53 views

Simplifying Mapbox vector tiles from GeoServer for beter performnce?

I use MapBox Vector tiles from GeoServer on my open source web site. How can I improve the performance of this service and how can I simplify the geometry of this service for performance? I know that ...
1
vote
0answers
91 views

QGIS 3 running slowly

I've been using QGIS 2.14 pretty successfully for about two years. I do also have Arc but tend to use Q more primarily because it did run considerably faster. I then installed QGIS 3 as I noticed it ...
1
vote
1answer
25 views

Improving performance of shapely crosses

I am unsure if this is the fastest way to test if LineStrings cross each other. Is there a better method. for line_1, line_2, in itertools.combinations(lines, 2): crosses = line_1.crosses(line_2) ...
2
votes
0answers
38 views

Speed up ArcPy CopyRows_management process on large feature layer?

I am attempting to automate an ArcMap process with Python and I am having difficulty with a particular part of a process taking too long when performed on larger datasets. The process is as follows: ...
3
votes
0answers
112 views

Arcpy 'Append_management' much slower than ArcMap Tool?

Basically I have a script that grabs data from a web service, parses it, stores it in an intermediary local fgdb, then appends that data to the feature class in the enterprise gdb. The portion of the ...
1
vote
1answer
46 views

Speeding up script to flag nodes within 100 feet of segments using PostGIS?

I'm working with two datasets, attempting to flag when an intersection is within 100 feet of a network subset. There are over 40,000 intersections and my network is ~ 1400 segments. The problem with ...
2
votes
1answer
88 views

Populating layer field with dict.values() in PyQGIS 3?

I've coded the script below in PyQGIS 3 to get the azimuth of starting or ending points for a line layer that touches a border. It works fine, but I want to populate the azimuth field layer with the ...
1
vote
0answers
82 views

Calculating nearest distance between points and Spatial Polygons in R? [closed]

So right now I have pretty large datasets, about 200,000 (lat,long) locations and a Large SpatialPolygonsDataFrame with a polygons list of length 428386 spread in a single city of around 450 square ...
0
votes
0answers
105 views

Improving speed of GeoPandas dissolve?

I am trying to dissolve grid spaces by category using GeoPandas' dissolve function, but it doesn't finish after hours of running and I want to make sure I'm not doing something wrong and/or there isn'...
3
votes
0answers
121 views

Slow loading of QGIS project?

I have a number of standard projects set up for QGIS users. Some of them take more than 5 minutes to load. Things recently got much worse suddenly - and I want to track down why. Are there any ...
-1
votes
1answer
67 views

Making looping through line segments for vertex points faster?

I am trying to speed up some current code that I have for looping through lines, getting their segments and ultimately the vertex points in Python. Can anyone recommend a faster method than what I ...
2
votes
1answer
30 views

Updating field in geodatabase table depending on other field using ArcPy?

I have a table in a file geodatabase that has "FieldA" and "FieldB". I want to update FieldB with one of two values, depending on if there are one or more records with the same value of FieldA. ...
0
votes
1answer
111 views

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

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
30 views

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

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
169 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
546 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
124 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 ...
5
votes
1answer
153 views

Speeding up searches on layer with many attributes?

I'm using QGIS 3 with my data in a PostGIS server on the same local network. I want to quickly search for a feature based on a certain attribute or attributes of my layer. This layer has ±2 million ...
0
votes
0answers
16 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
303 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
296 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
19 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
52 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
35 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
117 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 ...
1
vote
1answer
82 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
125 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
241 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
24 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
332 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
422 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
40 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
122 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
58 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 ...