The improvement of system performance
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 ...
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 ...
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 ...
4
votes
3answers
340 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 ...
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 ...
8
votes
3answers
578 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 ...
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
3answers
555 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
74 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 ...
