Stack Exchange Network

Stack Exchange network consists of 174 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.

3
votes
2answers
63 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
20 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 ...
1
vote
2answers
42 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
12 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 ...
0
votes
0answers
45 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 ...
3
votes
1answer
145 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
30 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 ...
1
vote
0answers
55 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-...
5
votes
1answer
173 views

Only union/dissolve intersecting features to save time?

I have one table of about 300k polygons, some intersecting but most do not. I need to dissolve the intersecting ones and also keep the non-intersecting ones. I only need the geometries, no attributes. ...
1
vote
0answers
64 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
47 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
174 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 ...
-1
votes
0answers
71 views

Improving performance of PostGIS equivalent to ArcGIS Identity tool?

My goal is to implement ArcGIS's identity tool in PostGIS as part of an effort to port an ArcGIS model builder model to PostGIS on a linux environment. The model by itself only uses "Select Layer By ...
2
votes
1answer
41 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,...
2
votes
0answers
238 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
45 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
57 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
61 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
23 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
37 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
68 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
83 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
47 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
33 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
95 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
33 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
37 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
284 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
32 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
59 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
144 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
44 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
80 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
64 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 ...
3
votes
1answer
175 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 ...
0
votes
0answers
55 views

Poor performance while opening a large number of tooltips using Leaflet?

The objective is to display about 3000 tooltips when the user ticks a checkbox in control layer. At the moment, I am binding each tooltip to a feature of geoJSON layer during the initialization. I am ...
2
votes
2answers
174 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
28 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
80 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
366 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
votes
1answer
343 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
132 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
37 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
50 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
216 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
200 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
75 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 ...
0
votes
0answers
133 views

Openlayers. Maptiler. Increase performance on mobile browsers

I face a performance issue whith using ol and maptiler.com maps by openstreetmap project. The zooming and pannings on my Samsung A5 2017 are very slow during serferring on my mobile chrome browser. ...
1
vote
0answers
132 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
35 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 ...