The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [performance]

Performance concerns how effectively a computing system uses resources.

105 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5
votes
1answer
123 views

Can I speed up search 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 ...
5
votes
0answers
278 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 \ --...
5
votes
0answers
3k views

ArcGIS Server performance comparison

Are there any recent comparisons/studies of ArcGIS Server vs. open source GIS servers in common tasks like providing a WMS/WFS, filtering data/search performance, and so on? We received a lot of ...
4
votes
0answers
390 views

Why my Geoserver on JBOSS/RHEL is slower than on Tomcat/Windows?

I have my Geoservers in 2 different environments: Tomcat on Windows and JBOSS on RHEL. I was guessing that JBOSS on RHEL will be faster, but to make sure I made some test plans with JMeter. Both: ...
4
votes
0answers
3k views

Point in Polygon using Rtree and Shapely

I am wondering what the correct syntax is for doing a point in polygon search using Shapely and RTree. I'm really interested in speeding the process up using the RTree index but am not having any luck ...
4
votes
0answers
488 views

Performance issues Tilemill with PostgreSQL and large datasets

I have a Tilemill project the size of europe. I developed my style-sheet by using a smaller dataset (size auf Austria) and everything was perfect. But now I did apply the same styles to my big europe ...
3
votes
0answers
74 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 ...
3
votes
0answers
71 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 ...
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
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 ...
3
votes
0answers
103 views

Most performant KNN method in postgis (<->, <<->>, st_distance)

My question is about the fastest way to order query results by approximate distance. I've seen conflicting information about this. My data are lat/lng points stored using WGS84 (SRID 4326). The ...
3
votes
0answers
79 views

Scaling postgresSQL database when searching polygons against points?

I am using our single server - CentOS 6.6 x64 16 CPU 24 GB SSD (PostgreSQL) 9.4.1 as our GIS database processing engine. This is part of the PostGIS software package installed on the server. I am ...
3
votes
0answers
439 views

Slow performance of ST_CONTAINS on MySQL 5.7

I'm using MySQL 5.7 and I have two tables, one containing the geographies of every census block group in the US, for a total of 223,325 rows. I have another table containing approximately 400 custom ...
3
votes
0answers
596 views

QGIS clipper taking forever

As the project requires, I built virtual raster catalog merging two raster DEM files. Because I don't want to use the whole surface of the new Virtual Raster, I went on to clip a desired rectangle. ...
3
votes
0answers
152 views

ITopologicalOperator2 operation Simplify taking very long in ArcGIS 10.3.1

I have a method that does a simplification of geometries. I have used this common code since ArGIS 9.2 without issues and it still works fine in ArGIS 10.2.2. Recently I upgraded a project to 10.3.1 ...
3
votes
0answers
547 views

Accelerating python looping process for A-star path finding on DEM surface?

I try to make an A-star Path Finding program base on tile-graph (image raster data as graph) where each pixel values represent as cost and elevation.. In my case, DEM raster data was called by using ...
3
votes
0answers
620 views

Performance difference between focal statistics (ArcGIS) and neighbor (GRAS or QGIS)

I tested minimum, maximum, and average neighbor (circle radius = 161 pixel) using ArcGIS, GRASS and QGIS: ArcGIS (10.1): it takes only one minute GRASS (6.4.3): it takes 123 minutes for every output ...
3
votes
0answers
311 views

Rendering performance

I am using ArcGis Java SDK for creating a map in my JavaFX application. I have a requirement to plot up to 500,000 graphics on graphics layer. When I do 100,000 graphics its performance is really bad. ...
3
votes
0answers
149 views

Running SAGA Processing algorithm from console takes much much longer than from GUI?

I have a road layer with 32000 features, and I want to find all the intersections. when I use processing->SAGA -> convert polygon/line vertices to points, it is all done in less than 5 seconds. ...
3
votes
0answers
771 views

How to understand output of ArcGIS System Monitor?

We had some performance issues with our enterprise ArcGIS server application, in this regard I have installed ArcGIS System Monitor v1.0.9. After installing and configuring the site, they are several ...
3
votes
0answers
776 views

ArcGIS 10.1 & SQL Server 2012

We currently updated to SQL Server 2012 and now we are encountering a slower performance when connecting to the geodatabase on SQL Server 2012. Here are the things that we tried to fix the issue: - ...
3
votes
0answers
108 views

Is there a way to constrain an FME.exe to certain amount of RAM?

If I have FME Desktop running on a workstation with a large amount of RAM (e.g. 128 GB), is there a way to constrain an FME.exe process to a certain amount of RAM (e.g. 48GB)? This question is ...
2
votes
0answers
35 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: ...
2
votes
0answers
244 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-...
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 ...
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 ...
2
votes
0answers
484 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 ...
2
votes
0answers
186 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 ...
2
votes
0answers
145 views

Faster equivalent of arcpy distanceTo method

Unfortunately arcpy distanceTo method is painfully slow. When speed is crucial, I am still using Avenue to work around it, but it is getting harder to transfer ArcView 3 to newer computers. As ...
2
votes
0answers
112 views

Understanding why arcpy.CreateScratchName() gets slower with more file geodatabases in folder?

In my ArcGIS Pro 1.4.1 application, I noticed that a short section of ArcPy code that creates a scratch name, and then uses that to create a file geodatabase (always in the same folder with the same ...
2
votes
0answers
91 views

Improve performance of a stand-alone table join in a Feature Service

I have an mxd with data-driven pages using Feature Layers from ArcGIS for Server (Workgroup Standard) with MS SQL Server Express. The DDP index layer has a join to a stand-alone table. I am ...
2
votes
0answers
78 views

postgis query performance

The db structure is more or less like this and can't be modified. I can only add some indexes but can't set for example foreign keys: CREATE TABLE adresspoint ( id character varying(3999) NOT ...
2
votes
0answers
461 views

Is there a comfortable way to generate efficient raster catalogs in QGIS?

Is there a comfortable way to generate efficient raster catalogs (such as in Arcgis), where polygon tiles are loaded as long as the scale does not hit a threshold value and images are only loaded when ...
2
votes
0answers
71 views

Large amount of time publishing to ArcGIS Online?

Publishing <5Mb tile packages to ArcGIS Online is taking more than 20 minutes. ESRI tech support has consistently given extremely vague answers that never solve and always reference server load. &...
2
votes
0answers
96 views

Performance of 'extract by mask' tool in PostGIS?

Context: A large raster is clipped to create a bunch of smaller rasters based on a bunch of shapefiles. I've used st_clip() which seems to take forever looping through the different shapefiles, so I'...
2
votes
0answers
285 views

What is the reason for the very poor performance of ESRI's file geodatabases on network drives?

I am asking this question because I am at a loss and dont have a good enough understanding of all the underlying operations going on 'under the hood' of Windows/Arcgis. What is the root cause of fgdb ...
2
votes
0answers
50 views

Making Tile Service fast in ArcGIS Server for Silverlight Viewer?

I am publishing a tile service in ArcGIS Server but when I call it in ArcGIS Silverlight Viewer it took a lot of time to open completely, and panning is very slow. What should I do to make my app ...
2
votes
0answers
309 views

QGIS extremely slow to clip vrt on Mac

I've been using QGIS 2.6 (Brighton) happily for awhile but suddenly it became extremely slow during certain operations, after being reasonably fast in past use. I'm merging NAIP JP2 files to virtual ...
2
votes
0answers
386 views

Improve Performance of Geoprocessing Service - GPServerSync.Load

I have a geoprocessing service in ArcGIS Server 10.1 that is a simple Print Task. The task is running as an Asynchronous service. It renders one MapService from the same ArcGIS Server instance, and ...
2
votes
0answers
274 views

Batch/Bulk Insert ADO.Net collection in MapXtreme Table

I am working on MapXtreme 7.1 and using MICommand to insert data in a table. I have more then 10,000 records and i am inserting these using a loop. That is Geometry = new MapInfo.Geometry.Point(...
1
vote
0answers
52 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
0answers
14 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) ...
1
vote
0answers
267 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' ...
1
vote
1answer
30 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
74 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 ...
1
vote
0answers
55 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
0answers
344 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 ...
1
vote
0answers
141 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 ...
1
vote
0answers
498 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
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 ...