Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with optimization
Search options not deleted
user 960
Use this tag when referring to improving or optimizing a process such as a script, application or software.
5
votes
Is there anyway to make GPModels with python scripts execute faster?
what makes you think that it is the python-part that takes time. without more information it would be more likely that the sql-query part could be optimized. do you have an index on the attribute you …
- 13.3k
2
votes
Accepted
Postgres/PostGIS Spatial Query Performance Problem
Hmm, this is not supposed to work at all in PostgreSQL as I understand it. The inner sub- select part of the query doesn't have access to the outer a_table. You can read about that on the bottom of th …
- 13.3k
2
votes
PostGIS - ST_Collect but only include POLYGONs not POINTs?
ST_CollectionExtract is what you are looking for:
http://postgis.net/docs/manual-2.0/ST_CollectionExtract.html
- 13.3k
3
votes
Accepted
Enhancing performance of join query for mapnik using PostGIS
I don't think a bbox anywhere can make the join faster. WHat is needed is a working index on table1.id and table2.fk_table1.
The bbox gist index filter will be more costly than joining on indexed inte …
- 13.3k
2
votes
Finding polygons crossed by line using OGR?
What a database like PostGIS does to speed this up is to first do an index, bounding box compare. It first finds all polygons that have bounding boxes interersecting with the bounding box of the line. …
- 13.3k
4
votes
Accepted
Qgis is slow with complex 'postgis query' layer. How to speed up?
Hallo
Is it the QGIS rendering that makes things slow or the PostGIS query. Is the query in the definition of a view or why does it need to med evaluated more than once?
If it is the PostGIS query t …
- 13.3k
10
votes
Fixing performance problem in PostGIS ST_Intersects
What you should do is put your big multipolygon in a table as single polygons (with ST_Dump) and put an index on it. Something like:
CREATE TABLE big_polygon as
SELECT (ST_Dump( ST_GeomFromText('a mu …
- 13.3k
28
votes
Accepted
Point in Polygon analysis of 200 million points
ST_DWithin was faster in my test than ST_Intersects. That is surprising, especially since the prepared geometry algorithm is supposed to kick in on cases like this. I think there is a chance that this …
- 13.3k