The improvement of system performance

learn more… | top users | synonyms

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 ...
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 ...
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 ...
10
votes
3answers
738 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 ...
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 ...
8
votes
2answers
893 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 ...
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? ...
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 ...
7
votes
1answer
911 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 ...
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 ...
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 ...
5
votes
3answers
663 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 ...
5
votes
3answers
893 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 ...
5
votes
3answers
3k 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 ...
5
votes
2answers
521 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 ...
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 ...
5
votes
1answer
546 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 = ...
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 ...
4
votes
1answer
331 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 ...
4
votes
1answer
306 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 ...
4
votes
1answer
715 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 ...
4
votes
1answer
765 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 ...
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 ...
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 ...
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 ...
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 ( ...
3
votes
1answer
699 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 ...
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 ...
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 ...
3
votes
0answers
128 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 ...
2
votes
3answers
844 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
163 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 ...
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 ...
2
votes
2answers
505 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 ...
2
votes
1answer
336 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 ...
2
votes
1answer
426 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 ...
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
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 ...
1
vote
1answer
398 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, ...
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
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 ...
1
vote
1answer
254 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
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
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 ...
1
vote
0answers
50 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
104 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 ...
1
vote
0answers
98 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) ...
0
votes
1answer
174 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: ...
-4
votes
2answers
626 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 ...