Performance concerns how effectively a computing system uses resources.

learn more… | top users | synonyms (1)

0
votes
0answers
21 views

How can I prevent ogr2ogr from trying to get the SRID from PostGIS?

I'm running ogr2ogr for a PostGIS to GeoJSON export like this: ogr2ogr -s_srs EPSG:4326 -f GeoJSON unique_geoms.json "PG:host=localhost dbname=local_data user=local_user password=local_pass" -sql ...
2
votes
3answers
179 views

Executing Python code takes a lot of time (more than 2 hours)? (Arcgis10.1)

I am executing this Python code, in which I am trying to determinate the position of neighbor parcel (north, south, east, west). It works fine but it took 2 hours for just 50 parcels! I think that ...
1
vote
1answer
29 views

GeoServer rendering performance significantly affected by vector icon size

I'm having the craziest GeoServer experience right now and I was hoping to get some input on what might be causing this behaviour. I'm using Apache Bench to benchmark rendering performance for a ...
0
votes
0answers
18 views

Any way to speed up my postgis topology creation?

I need to do topology aware simplification, and I'm investigating PostGIS's new topology extension. However it's taking a very long time to create the topology, and I'd like to know if there's ...
1
vote
1answer
33 views

Index to speed up ST_HausdorffDistance?

When comparing similarity of linestrings with ST_HausdorffDistance (or another type of similarity function), is there a way to use an index to speed up the search for similar linestrings?
1
vote
1answer
17 views

Does mixing geometries of different granularity affect POSTGIS index efficiency?

My POSTGIS table contains a lot of small non-overlapping geometries and I do mostly bbox queries. I would like to add larger / coarser grained geometries to the database (counties, provinces, country) ...
1
vote
0answers
11 views

Long delay when updating rows of a feature layer or modifying elements of a graphic layer using arcObjects in java

We are developing a simple AddIn for arcMap for the first time using arcObjects in java. The application consists basically on the following steps: 1. Obtain a Network layer which was loaded in ...
0
votes
2answers
50 views

How to improve the performance of an OpenLayers based API containing a large number of layers?

I have a GIS SDK with WMS layers and Vector layers (with information from Geoserver). I have methods for setting a style map, but I have a performance problem. When I set same style for 30 layers, ...
0
votes
1answer
44 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
48 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
67 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
68 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
88 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
167 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
83 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
4answers
150 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
24 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
115 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
55 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
60 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
54 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
35 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
110 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
110 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
26 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
31 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
108 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
107 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
161 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
57 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
160 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
143 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
369 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
253 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
233 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
182 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 ...
3
votes
2answers
342 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
496 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
64 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
251 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
337 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
66 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
1answer
48 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 ...
2
votes
1answer
192 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
57 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
308 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
109 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
70 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
241 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
201 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 ...