The improvement of system performance

learn more… | top users | synonyms

8
votes
3answers
1k views

Quantitative evidence supporting Solid State Drive (SSD) adoption for ArcGIS Desktop workstations?

Has anyone seen quantitative evidence supporting the use of a SSD (solid state drive) in an ESRI ArcGIS Desktop workstation? Or any GIS workstation for that matter? I keep reading that SSDs can be a ...
1
vote
0answers
31 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 ...
5
votes
3answers
659 views

Fastest way to merge a feature

I am writing a arc engine application that can take a shapefile, and merge a set of polygons together. Here is the code that I am using to merge the polygons: private static void ...
3
votes
0answers
124 views

ESRI geodatabase, Oracle spatial 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
0answers
47 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 ...
3
votes
1answer
108 views

Is Postgres and Disk IO limiting pgRoutings performance?

I am doing this Q&A style because I have done my google research and I could not find any thrustworthy and 'benchmarked' data. So I did it myself. CPU vs DISK as 'the limitting' factor on ...
36
votes
7answers
3k views

Best practices for PostGIS production environments?

What PostGIS documentation have you come across that has been helpful when tuning PostGIS for a production environment? I would like to get together with my DBA to setup a Postgresql/PostGIS ...
2
votes
1answer
160 views

Is there an optimum RAM configuration to use for FME Desktop?

I have a couple of workstations with 32GB RAM where fme.exe processes often exceed 25GB, if its available. And I'm looking to possibly add a 3rd workstation. I noticed in an FME2014 beta build some ...
4
votes
0answers
52 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 ...
0
votes
1answer
170 views

Do any of the SQL Server 2008 R2 SP 2 cumulative updates contain the MAXDOP spatial index fix?

I am troubleshooting ArcGIS 10.1 performance issues with SQL Server 2008 R2 SP 2 (10.50.4000) and the issue appears to be this MAXDOP issue: ...
3
votes
3answers
3k views

How to fix performance problem in PostGIS ST_Intersects?

I'm a newbie in postgis and I have a problem in query performance. This my query: SELECT DISTINCT ON (userid) userid ,ST_AsText(position), timestamp FROM table1 WHERE ST_Intersects ( ...
6
votes
5answers
4k views

ArcMap, ArcCatalog very slow to open on a new laptop with ample resources

I have a recent installation or ArcGIS Desktop on a 64 bit Windows 7 Machine, with 8GB ram, intel core i7 processor, and a solid state drive. It takes ~2 min to open either ArcMap or ArcCatalog from ...
1
vote
0answers
103 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 ...
5
votes
2answers
508 views

Python: how to speed up spatial search (nearest point)?

I'm working on a program that determines the closest location from a given point. The point cloud I'm testing against is very big (~800.000). However, this doesn't really explain why my implementation ...
4
votes
1answer
319 views

How to use more than one CPU?

I'm creating a real time traffic application. I read the AVL car data from a web service and insert the records in a PostgreSQL table Then a trigger calculates the closest link and if there is a ...
2
votes
0answers
128 views

Performance issues after upgrading from 9.2 to ArcGIS Mobile release 10 [closed]

We have recently upgraded an application originally written for ArcGIS mobile release 9.2 to the release 10. Even though we have just made a code conversion (no code refractory was applied), the ...
1
vote
1answer
389 views

How to improve poor performance times for PostGIS 2.1 Tiger Geocoder?

I've recently upgraded my PostGIS DB from 2.0 to 2.1. I initially followed the instructions from Waiting for PostGIS 2.1 - Install PostGIS Tiger Geocoder as an Extension and 2.7. Installing, ...
2
votes
1answer
239 views

OpenLayers and Geoserver. Using multiple Servers for tiles

OpenLayers allows the wms layer to specify up to 4 servers to permit the browser to connect to a server multiple times Has anyone had any experience in mapping those for servers to four Physical ...
1
vote
0answers
97 views

PostGIS raster functions aspect and slope slow

I am trying to compute the raster and slope values from a DGM table (8184 x 5159) imported from tif file tiled in 500x500 tiles. In my query in which I merge the DGM table with a vector (point type) ...
8
votes
2answers
882 views

Is there workaround for very slow ArcSDE 10.1 data display

I'm suffering from very slow viewing data of and ArcSDE database from an Arcgis engine application, the SDE database is in localhost so there's no network issues. but i still don't know the reasons ...
5
votes
5answers
446 views

Improve performances on distance coverage routing - PostgreSQL

I have to create layers of land coverage from one point to anywhere around on a given street network for a given distance (ex: FROM house, DISTANCE 30000m) An important factor to understand; I need ...
4
votes
3answers
447 views

How to efficiently find points within an elliptical area?

Using PostGIS 2.0.0 I need to filter the results of a function, which returns many POINTs, to find the ones that lie within an elliptical area defined by two points and a distance (all parameters ...
27
votes
4answers
3k views

Performance of ArcGISScripting and large spatial data sets

I am currently writing a python script using the arcgisscripting module to process a reasonably large data set (~10,000 records in total) normalised over a small number of tables, 8 in total. The ...
-4
votes
2answers
620 views

QGIS 1.8.0, 3.68 RAM, 2.4GHz — Slowwwww performance

What can I do to speed up QGIS panning and zoom in/out? I did not include any layer information in my question because it is still subjective. It's just that I cherish having an open source gis ...
10
votes
3answers
721 views

How to speed up queries for raster databases?

I have a raster database in postgresql/postgis with these columns: (ID, rast, data_of_data). 'rast' is the column that has raster files in WKT format. An example query to find the DN value of a ...
4
votes
1answer
305 views

Improve database performance for geospatial

I have a database with osm data imported with osmosis tool. I want to search for the nearest POIs from a given point. For this purpose, I perform this query: select id from nodes where ...
3
votes
1answer
79 views

Web map graphics and performance optimization

With a web map (in this case, Bing Ajax API v7), what's more important for performance - the number of individual map shapes/graphics drawn on the map, or the total number of vertices drawn on the ...
8
votes
1answer
346 views

Will hundreds of attributes cause performance problems in an ArcGIS Server layer?

This relates to ArcGIS Server 10.0 SP1, with data served from a file geodatabase polygon featureclass. 1) For performance reasons, is it a bad idea to have a featureclass with hundreds of attributes? ...
5
votes
1answer
543 views

ImagePyramid tuning in Geoserver

I am running several WMS layers from a GeoServer (2.2 RC3 at the moment of writing). All layers are ImagePyramids with sizes ranging from 100GB to 1TB in size. I have read the GeoServer on Steroids ...
5
votes
1answer
180 views

How can I increase performance on inserting features with polygon geometry?

I have a problem when inserting features with polygon feature class in FGDB. This is my code: ... initialising some fields (does not affect performance) m_featureBuffer.Shape = ...
7
votes
3answers
207 views

What would be 'normal' processing time for a large postgis query

I have two datasets which I want to spatially join (with an intersect). The first dataset consists of 9 million addresses. The second dataset consists of 12.000 neighbourhoods. I want the add the ...
3
votes
2answers
179 views

ArcGIS Server: Better to have one massive map service or multiple smaller services?

I have a Silverlight application that consumes around 30 map service layers at different types. The service layers are categorized based on type and only applicable to certain screens of the ...
5
votes
3answers
2k views

Slow IE8 responsiveness with OpenLayers and many features

Background Adding about 700 sites to an OpenLayers Map. Firefox 11 and Google Chrome display the sites just fine. IE8, which is the organization's standard and will not be upgraded for the ...
4
votes
1answer
706 views

How does QGIS handle opening files and how can I improve this?

We are using shapefiles with a large attached database to it (162 Mb for 133000 features) Opening this shape file on a remote server takes about 5 minutes whereas DivaGIS takes 7 seconds for the same ...
1
vote
2answers
2k views

ArCGIS Server 10/10.1 And Sql Server 2008

Is there any compulsion that SQL server 2008 and ArcGIS server 10/10.1 should be installed on same server machine and is it possible to install SQL server 2008 and ArcGis server on separate server ...
4
votes
1answer
758 views

ArcPad 10 Performance Tips

I've encountered some performance issues when developing in ArcPad 10. The first is the loading of the map file. It takes 1 minute with sample data, and once opened each form takes 1 to 2 sec to be ...
2
votes
3answers
838 views

Cut many lines with many polygons: Too much for my CPU/RAM?

I have a line-shp (80mb) and a polygon-shp (5mb) and want to intersect them. In result, the lines (contours) should be cut by the polygons. After using one of the tools "Vector -> Geoprocessing ...
2
votes
1answer
333 views

OpenLayers deploy: what libs does selectFeature rely on?

I am trying to minimize my code by modifying OpenLayers deploy configuration file in order to reduce its load time. However, It seems that I can't include all necessary libs that ...
1
vote
1answer
253 views

How do I make a more Bandwidth-friendly map overlay?

I performed a map overlay in Google Earth then saved the overlay as a KMZ file. Then logged into my Google Maps account and uploaded that KMZ file so the map overlay would appear on Google Maps. The ...
1
vote
1answer
98 views

Which SRS is computational more effective to store continental scale data? (given some conditions)

For a Precision Agriculture application I need to make calculations in UTM projection. The data will be stored in Postgis and is made of soil samples results (point data) and field boundaries of many ...
1
vote
1answer
196 views

Free GeoTIFF Overlay and Tiling (i.e. Indexing) Analyser?

Has anyone come across a shareware/freeware tool for analysing the overlays and tiling (i.e the internal indexing) of GeoTIFF images? What would be excellent would be something like a GeoTIFF tuning ...
1
vote
1answer
524 views

OpenLayers GML Polygon Performance

I'm working on a project where we have a large number of very detailed polygons being displayed on a image using Openlayers. The polygons are added to the map through a GML feed. We are having end ...
5
votes
2answers
4k views

OpenLayers canvas renderer - redraws all features on selecting a single feature

I am currently trying to learn more about OpenLayers, and I'm coming up against performance / behaviour issues that I wouldn't expect to see. To elaborate... I have combined this example for ...
15
votes
3answers
3k views

How can I optimize pgrouting for speed?

I am using pgrouting on a postgis database created through osm2pgrouting. It performs very good on a limited dataset (3.5k ways, all shortest path A* searches < 20 ms). However since I have ...
3
votes
1answer
695 views

How to increase performance of tile caches if vendor parameter filters are needed?

My application uses vendor parameters to filter the data. It takes some time to generate all tiles on the server. Therefor I'm trying to increase the performance of the application. I'm using ...
2
votes
2answers
503 views

How do I performance test ArcGIS 10.0 in a Citrix environment?

I have a project (ArcGIS 10.0) for a client that could potentially be deployed in a Citrix environment. It will contain a fairly complex Add-In that will, among other things, import data, allow them ...
5
votes
1answer
133 views

Is there a performance penalty when using security-enabled services in ArcGIS Server?

I enabled security on our installation of ArcGIS Server last week, and modified an existing application of ours to use the service tokens to access the services. The application works with the new ...
7
votes
1answer
906 views

Should I split MultiPolygons into Polygons?

In the system I'm implementing I have a table T1 with an associated geometry. Most of the geometries are a set of n polygons, with 10 < n < 100. At the moment in the table T1 I have a geometry ...
5
votes
3answers
885 views

arcpy taking longer and longer in a loop

I am looping through an amount of point arrays, creating data on the fly. The features/arrays, are largely similar in size. One thing I have noticed, is that when I start the process, the time it ...
2
votes
1answer
425 views

Oracle tracing, bind variables, and ArcSDE

Oracle tracing with TKPROF is the recommended way to troubleshoot data access performance problems with SDE/Oracle. Unfortunately, queries that differ in any way are considered "different" and ...