Performance concerns how effectively a computing system uses resources.

learn more… | top users | synonyms (1)

0
votes
2answers
59 views

Why the execution of a query is very slow using PostGis?

I'm applying this Query to 8257800 point but it's taking 15 hours and it didn't return a results. SELECT a.gid , b.gid, st_distance(a.geom,b.geom) FROM shp1 a, shp2 b where ...
1
vote
1answer
25 views

Taking a long time to load tables from oracle to QGIS

My workplace has an oracle database with a very large number of spatial tables. Therefore, it takes a long time to load the oracle connection in QGIS. Does anyone know how this could be speed up?
0
votes
0answers
17 views

Spatial filter taken more time for running any other way to improve speed

I had number of buildings in data (around 600000) i want to check if any building captured less than shape area 25sqm should snap to existing building. i have used spatial filter but it is taken more ...
3
votes
2answers
104 views

Efficient ways to read table data from a large feature layer?

I have a feature layer that contains about 460,000 records and it currently takes about 20 minutes to read that table using the arcpy.da.TableToNumPyArray() tool. Is there a more efficient way to read ...
2
votes
1answer
65 views

Is there a way to improve the time for opening a QGIS project?

We have a QGIS project using postgresql database "made with" osm2pgsql. The database is about 68GB. Our Configuration is : AMD-FX 8 cores @ 4.7Ghz 32 Gb RAM 500 Gb SSD (read/write 600Mb/s) Ubuntu ...
-1
votes
0answers
46 views

Why does Select Layer By Location with SWITCH_SELECTION hang?

When I try to follow the solution offered at How to SWITCH_SELECTION after Select Layer By Location in ModelBuilder?, which I think should work the process hangs. Is there something that I may be ...
0
votes
0answers
14 views

Improving Global Scene transition when changing location using bookmarks in ArcGIS Pro?

Using ArcGIS Pro 1.0.0 I have: Created a new project using Global Scene.aptx Switched the Basemap to National Geographic Navigated to and created Bookmarks for some countries of different sizes: ...
0
votes
1answer
20 views

How to make Feature to Raster tool run faster

Suppose you have a feature class that you need to convert to a very detailed raster (where each cell size is quite small). With a cell size of 0.0092908447 in the Feature to Raster tool, the procedure ...
0
votes
0answers
28 views

Lizmap recommended layer settings for performance (faster navigation)

I am currently using Lizmap and I really love it. There are a great bunch of options available which makes it pretty customizable. The only "but" I can mention is speed. My map seems to be loading ...
1
vote
1answer
38 views

Performance is downgrading with multiple feature datasets design for ArcGIS?

My company develops a spatial planning solution since 2009. Initially it was an ArcMap application to create and maintain spatial plans (competing with AutoCAD folks) but recently we developed ...
1
vote
0answers
58 views

Why is SAGA kriging slower in QGIS than in SAGA itself?

I'm using QGIS for a while. In my opinion the SAGA kriging tool (processing toolbox) is very slow. Is that an QGIS issue? I tried to interpolate a point layer with 300.000 points (I know it is big) ...
1
vote
2answers
66 views

Performance Monitor of ArcGIS for Desktop?

Is there a way/tool that could basically report what ArcMap 10.2 is doing? I can't really explain it, so I will show you what I mean. Now mind you it doesn't have to be exactly like this. ARCMAP ...
1
vote
1answer
88 views

How can I speed up a slow ArcGIS Server 10.2 - PostgreSQL (9.2) ST_Intersects query?

I am troubleshooting a slow st_geometry query in Postgres 9.2 that uses ST_Intersects--a basic Select from table where ST_Intersects type query. table_extent ...
1
vote
0answers
34 views

Mapnik performance - large polyline dataset

I'm working with a very large set of polylines - contour data - to be rendered with Mapnik. (The contours are generated using gdal_contour from SRTM data.) At present I'm storing them in PostGIS and ...
0
votes
1answer
50 views

Display more than 1000 lines on web map

I've a scenario that I need to display many lines on the map (for instance all road links of Manchester in UK). I am using Leaflet as map plugin. I use geoJSON as source of data, when I try to load ...
2
votes
0answers
69 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 ...
4
votes
1answer
74 views

PostGIS: Strategy for fastest select by BBox with an ORDER BY polygon area clause. Cluster?

Update 2 (below) suggests 14% of the table geometries are stored out-of-line with the rest of the table records. This may be a useful clue. The Problem: We've got a table with appx 170,000 WGS84 ...
-1
votes
1answer
50 views

How to reduce Overpass way QL statement output to just tags?

I am new to Overpass API. Ran this query [way(around:10.0,37.559391,-122.301529);out;] in overpass-turbo.eu and getting lot of information about nodes. I just need to know whether it is valid way or ...
0
votes
1answer
32 views

ogr2ogr Spatialite to csv very slow

I am using ogr2ogr to extract point data from a Spatialite db to a csv file:- ogr2ogr -f "CSV" commandtmp.csv dtm2.sqlite -lco GEOMETRY=AS_XYZ -progress -explodecollections the Spatialite db is 7GB ...
1
vote
0answers
75 views

Spatial query by ESRI ST_Geometry take too long

I am using ESRI ST_Geometry in my application, and I found that the spatial query is rather slow: The following sql is used for query pois inside a certain bounding_box: select * from ( select ...
0
votes
0answers
27 views

Showing large number of polygons in SpatiaLite on Android map?

I have 2,300 complex multipolygon features in an offline SpatiaLite database. How can I show them on an Android map without slowing the map to a halt?
1
vote
1answer
384 views

How to improve ArcGIS Desktop 10.2.2 and Postgres 9.2 PostGIS geometry performance?

I'm experiencing sever performance issues on a polygon featureclass(PG_GEOMETRY) in a PostgreSQL 9.2 database from a 10.2.2 client. Even when zoomed to an area with 10-20 features within the extent. ...
1
vote
1answer
47 views

SQL query within Select tool in ArcGIS model going very slow

I have been working on finding the shortest routes from a series of residential blocks (a shapefile with polygon centroids) to a a number of recreational areas. I have a total of 9 resulting OD cost ...
1
vote
1answer
18 views

Avoid sending CSS with each search in CartoDB

We’re developing a project with CartoDB and we want to show each element with a custom image. We are doing this setting the sublayer.setCartoCSS() with something like this: cartocss: "#map { (…) } ...
0
votes
1answer
103 views

GeoTIFFS on Geoserver are served slowly, at too low resolution

I have a bunch of large, high resolution GeoTIFFs, that I am serving using GeoServer. I also have a prototype client I wrote using Leaflet. The resolution of the TIFFs is quite high, but despite that ...
2
votes
0answers
37 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 ...
0
votes
0answers
37 views

Performance problem WMS layers arcgis Server

I am learning to work with ArcGIS for server and with Javascript, HTML5 and CSS3. I have GIS knowledge but this technical part is new to me. I have published WMS layers to my ArcGIS server and can ...
0
votes
0answers
22 views

Multibuffer in arcpy is too slow?

I have to make multibuffer to a several shp's (30 or +) and with this code the it takes 30 minutes or more. import arcpy,time,glob,os def multibuffer (probe,Zona_trab,nombarch3,recortes2): ...
2
votes
2answers
131 views

Python Script tools for ArcGIS 10.2 is very slow (get raster properties)

I am using python script tools for ArcGIS 10.2, under Windows 8.1 64bit. When I am using the arcpy.GetRasterProperties_management() command, it's very slow to process the data. For example. I tried ...
0
votes
1answer
154 views

Chrome/Firefox Performance Issues

Just curious if anyone else is having performance issues with Chrome and Firefox while using an arcgis javascript web application. I have been developing an application that works great in Internet ...
5
votes
2answers
230 views

PostGIS ST_Union Performance

I'm trying to execute a 'dissolve' operation in PostGIS using the ST_Union command. The input layer is admittedly quite large and complex. By 'large' I mean 57,771 features, with number of vertices ...
0
votes
1answer
58 views

Connecting to ArcSDE with arcpy is slow (ArcSDESQLExecute)

I'm creating an API which will allow queries to be performed on my GeoDatabase. I'm using ArcSDESQLExecute to connect to ArcSDE (backed with an Oracle database). Creating the connection object is very ...
3
votes
0answers
129 views

Why is QGIS so much faster on Windows than Mac? (or: Why is QGis so slow on macs?) [closed]

I just went from temporarily using a Windows 7 machine with 4GB of RAM and no video card as far as I know. I'm now using a mac with 16GB of ram, etc. Its a much more powerful machine. However, QGis's ...
1
vote
0answers
59 views

Fastest method to join a lot of tables

i have a lot of feature class (see figure 1) the objective is to create one feature class that combines the attribute table (especially one field) of each feature class the attribute table of each ...
0
votes
0answers
40 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
228 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
103 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
52 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
44 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
24 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
17 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
302 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
131 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
70 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
160 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
125 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 ...
2
votes
1answer
74 views

Time required to get results by solar radiation tool?

How much does time does the ArcGIS solar radiation tool take to give solar map for day of about 50 km area?
1
vote
1answer
267 views

Slow performance with Add 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
214 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
166 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 ...