Tagged Questions

Performance concerns how effectively a computing system uses resources.

learn more… | top users | synonyms (1)

0
votes
1answer
22 views

Will a tile cache serving PNG tiles be slower than JPEG?

I'm trying to figure out the best format to serve my tiles. I'm creating an ESRI tile cache. It will be consumed internally through ArcMap from our server, not online. There are a lot of different ...
1
vote
1answer
31 views

slow Python script pulling from an iSeries database

I've converted and updated some python scripts that exported data from an iSeries database (HTE) to Access to export the same data to a fgdb. My biggest issue is the time it's taking to export the ...
2
votes
2answers
39 views

Maximizing Code Performance for Shapely

I've written this code in order to calculate the percent cover of grassland within a national park, within 20km^2 of points of recorded occurrences for a species. It is designed to only consider the ...
1
vote
0answers
37 views

Mosaic many rasters in ArcGIS is slow

I am trying to merge 166 tiles into a single world raster (500 meters resolution) through ArcGis "Mosaic to new raster" tool with a simple Python script. The process seems incredibly slow. Before ...
0
votes
1answer
48 views

Painfully slow performance with Join and Calculate Field

I have a point layer and a table with approximately 100 fields. I need to join the table to the point layer based on a key field and create a new shapefile / feature class. This script has been ...
10
votes
3answers
147 views

Using Label classes vs Definition queries - which performs the best?

Which would provide the best performance for working within ArcMap with very large datasets stored in an ArcSDE geodatabase? Multiple label classes using complex SQL queries to label specific ...
1
vote
1answer
53 views

Testing point in polygon overlay performance of Intersect, Spatial Join and Near in ArcGIS for Desktop?

In answers and comments to Select points within a polygon and update attributes I think it is being suggested that Spatial Join (Analysis) and/or Near (Analysis) may be faster than Intersect ...
2
votes
3answers
109 views

Openlayers Vector Rendering

I've just added a couple of more WFS backed vector layers to a map and the performance has dropped. Whilst debugging this I've noticed that openlayers is considering every feature in the visible ...
0
votes
0answers
19 views

Problem with Performance when accessing selected Features from PostGIS layers in QGIS using Python

I have 2 PostGIS layer in my QGIS project. They have about the same amount of data and a similar structure except that layerX has its PK on a single column and layerY has its PK on 4 columns. When I ...
4
votes
2answers
89 views

What is the significance of the SDE lineage length?

ORA-55378 left a great answer to my question: Does a high number of SDE_state_lineages slow performance? But, I realized I don't really understand what lineage length means and how it affects ...
0
votes
0answers
52 views

ArcPy loops/cursors faster without background processing?

I am running loops via cursors and raw Python in Arcpy. Within the loop several processes take place, selecting shapefiles and converting to raster, clipping, running euclidean distances, extracting ...
2
votes
0answers
34 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 ...
1
vote
1answer
45 views

Postgres Performance with Radius Searches

Im porting an application from mysql to postgres, and have several tables with 500k+ rows in each of geo points (lat, lon). In mysql i used a bounding box query with haversine to select rows within a ...
1
vote
0answers
33 views

QGIS fTools very slow adding random points?

I am currently on windows 8.1 qgis 2.2 and almost everything I am trying to do using ftools is too slow. For example: using divaGIS world countries layer (.shp) when I try adding 500 random points ...
2
votes
1answer
74 views

ArcSDE performance and table changes on upgrade from 9.3 to 10.1?

I'm using ArcSDE 9.3 and SQL Server 2008 R2 and I want to migrate from ArcSDE 9.3 to ArcSDE 10.1. Is there any performance differences between ArcSDE 10.1 and ArcSDE 9.3 ? Is there any change ...
2
votes
2answers
75 views

What is the most efficient method to iterate geoprocessing operations through an attribute table?

I want to calculate the clipped raster layer percentage for a shapefile consist of overlapping polygons, since ArcGIS doesn't support tabulate area for overlapping features, so I used a loop to ...
1
vote
1answer
18 views

Compressing multiple static layers to single layer to make web map loading faster?

In our web application there are many layers to be loaded, this cause the loading of map very slow. I am seeking a way to compress multiple static layers to a single layer to make the loading ...
1
vote
0answers
26 views

Speeding up arcpy's TextElement.delete()

I'm making tables to go on data driven pages. For each page there are a series of tables that are produced. The elements of the tables are made using the clone method. The problem is that it takes ...
0
votes
1answer
78 views

How to automatically generate least-cost paths between several polygons?

What is the fastest way to automatically generate least-cost paths (LCPs) between several polygons with ArcGIS ? I created a python program to do this by using the functions "CostDistance" and ...
2
votes
0answers
90 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. ...
2
votes
1answer
111 views

Cripplingly Slow Performance While Georeferencing in ArcMap 10.1

Just last night I started having an extremely frustrating problem with georeferencing, something that has been integral to my job for a few years now, and something I've never really had a problem ...
0
votes
0answers
43 views

Postgresql Postgis Query is taking long time

I have a table that included only 472 rows and geometry of table is Multipolygon. I am sending query to databse via PgAdmin III select * from mytable // this query takes 99413 ms this is vey long ...
3
votes
1answer
124 views

Benchmarking QGIS and ArcGIS for Desktop speed for “significant buffer on very large shapefiles”?

I am a newcomer to the world of GIS. I realized that QGIS was relatively similar to ArcGIS for Desktop. I would like to know if the two programs are comparable in terms of computational speed. For ...
4
votes
1answer
86 views

Does a high number of SDE_state_lineages slow performance?

In our SDE database, the SDE_state_lineages table has around 200,000 records, the SDE_states has around 900, and our SDE_versions table has around 1,300 records. We've been having performance issues ...
12
votes
2answers
339 views

How is the data access cursor performance so enhanced compared to previous versions?

The data access module was introduced with ArcGIS version 10.1. ESRI describes the data access module as follows (source): The data access module, arcpy.da, is a Python module for working with ...
2
votes
3answers
229 views

How can I work with very large shapefiles (~1 GB) in QGIS?

I'm performing some basic spatial analyses on a large database of traffic injuries in California between 2003 - 2011. Because the dataset is large (nearly 1 GB of points), I'd like to first cut it ...
2
votes
3answers
163 views

Iterating using search cursor and layer selection performance?

I'm trying to use the results of a search cursor to iteratively make selections on a feature class and then create new feature classes (so you get a new feature class or shp for each unique value in a ...
5
votes
2answers
150 views

Leaflet: How to enable pan & zoom while GeoJSON still rendering?

I've overlaid a huge GeoJSON geometry on top of my Leaflet map, covering about 20 countries' borderlines (about 1,5 million vertices) using "L.geoJson". Each time I zoom in/out, the computer has to ...
2
votes
2answers
192 views

Most reliable way to import large dataset with osm2psql

I know my question is similar to slow import via osm2pgsql to postgresql database and Optimizing osm2pgsql imports for OSM data but as we currently have quite some problems importing a large set of ...
1
vote
2answers
336 views

Creating tile packages (.tpk files) in ArcGIS for Desktop using multiple cores?

It takes hours or days to create tile package files on my workstation, which has 4 cores, 32G ram and a SSD drive. I noticed only one core is in active use while it is working. Is there a way to ...
1
vote
0answers
51 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 ...
5
votes
2answers
212 views

Creating numpy.array with variable number of fields to test arcpy.da.ExtendTable performance?

There was an ArcPy Café blog posting entitled Adding Fields: Performance Tips which advocated: Two approaches to help increase performance when adding numerous fields to a table or feature ...
4
votes
1answer
244 views

How to find the distance to the nearest coastline from a land-based latitude/longitude point?

I'm completely new to GIS and unsure what I need to solve this problem: In the image above turquoise is actually land. Sea is white. I tried using the NASA Distance to the Nearest Coast data dump ...
1
vote
0answers
59 views

SDE Performance issue with SQL Spatial labelled lines on one server

Here is an issue that has stumped ESRI and SQL Server experts alike. I ask it here just to get more people thinking about it. Exhibit A is this screencast. I have two servers: ROGIS: A dedicated ...
1
vote
0answers
40 views

Performance Tuning on CartoDB

What kind of tuning can be done on your own cartodb instance to speed things up (outside of sql query optimization and indices)? Is there any documentation on this? If the records do not change, could ...
3
votes
1answer
178 views

Can ArcGIS Online navigate and identify large GIS datasets?

For my upcoming project, I want to see if ArcGIS Online can provide a viable solution. Users will need to have access to webmap on their desktops with basic navigation and identify. This will be an ...
1
vote
0answers
56 views

How to Buffer with Dissolve ALL on very large polyline dataset? [duplicate]

So I have a fairly large polyline network covering a decent chunk of North America, containing just shy of 900,000 table records. I want to do some very simple "GIS 101" kind of processing to it -- I ...
3
votes
2answers
240 views

Tuning Esri Geodatabase on Oracle Spatial (SDO_Geometry) performance?

We are storing data in a Geodatabase on Oracle 11g using Oracle Spatial with SDO_Geometry, and then consuming that using ArcGIS server 10.2.1. The performance is very slow, because we are talking ...
1
vote
1answer
88 views

Why a severe performance difference using deleteSearchedRows

The issue I am having involves two versioned tables. A function deletes 48 rows from Table A and and 48 rows from Table B using deleteSearchedRows. However, the delete from Table A takes roughly 4 ...
1
vote
0answers
68 views

Do ArcGIS clients that direct-connect to postgresql/postgis databases override configuration settings?

I went in to modify some settings on a Postgresql database via the PGAdmin config editor and some of the settings don't have their default values and they are higher because they've been overridden ...
1
vote
0answers
219 views

How to fix the possible memory leak issue in Openlayers 2.13.1 version?

Recently we have upgraded the Openlayers from version 2.12 to 2.13.1. However the performance of the new version is not that promising, infact it has degraded exponentially. I have a draggable model ...
4
votes
2answers
184 views

How to transfer attributes to thousands of local points from ArcSDE feature class with millions of polygons?

I have a set of points and a huge feature class with topographic information (OS MasterMap for who knows it). I'm talking millions of polygons huge. I want to transfer attributes of the polygons to ...
0
votes
1answer
44 views

Why can't I perform any operation over a 700MB MIF file containing 5 multipolygons? It takes forever

I'm trying to work with a MIF file containing 5 really big multipolygons, but every operation I try takes hours, or just crash because of memory issues. Mainly using ogr2ogr, to transform MIF file to ...
2
votes
2answers
120 views

Compacting ESRI file geodatabases…good practice?

Is there a way to quantify the effect of compacting your ESRI file geodatabase(s) on editing performance? I currently use ArcInfo(10.0). I have a 769 MB fgdb that holds my most used/edited datalayers ...
1
vote
0answers
28 views

Forcing Hash Join Query Plans using PostGIS

I'm currently testing PostGIS 2.0 in a Greenplum Appliance (Postgres 8.2 based) and have hit an incompatibility between PostGIS and the MPP Greenplum environment. The basic query below can't be ...
0
votes
1answer
127 views

JS/browser API library to show/interact with many markers with the best performance?

What's the best Javascript library that can show about 50000 (and more) clickable markers without resorting to things like clustering markers,etc? The markers are clickable and I want to associate ...
1
vote
2answers
130 views

spatial database vs spatial datastructure?

I am building an automated system that has to process several hundred spatial queries in the form of a polygon every day. The queries have to return both spatial and nonspatial data from different ...
1
vote
1answer
855 views

Which plugin can draw topoJson right within Leaflet without conversion?

I already have asked how to reduce file size and increase performance for publishing spatial data on the web using Leaflet, here. A conversion to TopoJSON has reduced the file size by approximately ...
3
votes
2answers
147 views

Fastest Way to Intersect Envelope with Multiple Feature Classes ArcObjects

I have the situation where I am doing a large number of intersections and I need to do them fast. The situation is I have a iMap with 1 or more layers and a series of envelopes, lots of envelopes. I ...
0
votes
0answers
38 views

Geoserver lock itself , performance problem

when 10-15 users use my wms layers, geoserver doesn't give response, or i hava tiledmap and when i zoom in and same level geoserver doesn't give any response so image is not appear. Is there any ...