Tagged Questions

The improvement of system performance

learn more… | top users | synonyms

0
votes
1answer
28 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: ...
7
votes
1answer
338 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 ...
-4
votes
2answers
234 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 ...
8
votes
3answers
278 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
212 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
65 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 ...
4
votes
1answer
307 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
134 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 = ...
6
votes
3answers
165 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
132 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
1k 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 ...
3
votes
1answer
295 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 ...
5
votes
5answers
344 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 ...
1
vote
2answers
1k 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 ...
3
votes
1answer
461 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
575 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 ...
1
vote
1answer
205 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
76 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 ...
8
votes
3answers
602 views

Looking for quantitative evidence supporting SSD adoption

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
1answer
384 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 ...
6
votes
4answers
2k 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 ...
3
votes
3answers
2k 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 ( ...
2
votes
0answers
116 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 ...
3
votes
2answers
3k 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 ...
4
votes
3answers
348 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 ...
3
votes
1answer
557 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 ...
13
votes
3answers
2k 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 ...
1
vote
1answer
151 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 ...
2
votes
2answers
388 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
117 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 ...
2
votes
1answer
273 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 ...
5
votes
2answers
443 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
676 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 ...
7
votes
1answer
304 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
1answer
774 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 ...
29
votes
7answers
2k 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 ...
23
votes
4answers
2k 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 ...
2
votes
1answer
343 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 ...