Questions tagged [performance]
Performance concerns how effectively a computing system uses resources.
755
questions
-1
votes
0
answers
32
views
Optimizing GeoServer and PostGIS for High-Concurrency Survey on AWS
To manage performance and scalability for a survey system involving 600 concurrent users, hosted on an EC2 AWS instance with a PostGIS database and GeoServer, and planned for online surveying using ...
-1
votes
0
answers
40
views
Website created using QGIS2Web plugin hosted on Microsoft Azure is very slow
I have first merged around 100 shapefiles into one and then used QGIS2Web plugin via "OpenLayers" functionality to output a website folder. The size of the merged file (filename: ...
4
votes
1
answer
114
views
Reasons of slow intersection of two GeoDataFrames using Python [closed]
I am trying to find the largest intersecting area for each Polygon in a layer1 compared to the geometries in a layer2 in python. I use geopandas.overlay for it.
However, the geometries in layer2 don't ...
2
votes
1
answer
111
views
Does ST_Simplify help on lines?
I have a function that selects all lines whose geometry fall into given tile envelope.
There are a couple millions of lines with proper indices on the table.
Would the query perform better if I would ...
2
votes
2
answers
74
views
Optimizing river network features queries in ArcGIS JavaScript SDK
I am working on a map to visualize river network data using ArcGIS SDK for JavaScript. The data I’m using is from this ArcGIS feature service published by the CLMS. The data includes a dozen feature ...
1
vote
0
answers
59
views
Working with very large GeoTIFFs using QGIS
I would like to ask for advice on working with very large GeoTIFFs.
I have downloaded several large GeoTIFFs, then I load them into QGIS and combine them into a virtual raster.
Since I need the ...
0
votes
1
answer
63
views
Getting GEE data faster
I need country-month level nighttime lights data. I have already printed the data using the minimum example on the https://code.earthengine.google.com/ platform, but the current problem is that it ...
-2
votes
1
answer
68
views
Google Earth Engine Computation timed-out Error
I adapted the GEE script from the UN-Spider website, which now returns an computation timed-out error after 12 hours. The script basically calculates the flood extent and then overlays it with ...
0
votes
0
answers
90
views
Performance difference between xarray open_mfdataset and open_dataset
I'm dealing with CMIP6 Scenariomip data, I have eight ESMs precipitation grid that each one is composed by multiple netcdf files. There is one ESMs's netcdf files are seperately reserved every decade, ...
0
votes
0
answers
126
views
Low performance when writing a large xarray.DataArray with dask
I'm preprocessing HMASR data, the data contains multiple data files with format of netcdf, and each tile (1X1 degree) is a nc file. So I read it through xarray open_mfdataset() to mosaic it spatially ...
2
votes
0
answers
66
views
PostGIS slow performances on small table and basic SELECT query
A few weeks ago, I received a query to install a PostGIS database for a few of my users. I'm not familiar with this but yet installed quite simply the extension using the sudo apt install postgresql-...
0
votes
1
answer
230
views
QGIS and remote PostgreSQL/PostGIS (in cloud) slow performance
I am using QGIS 3.28.11 version and in backend I am using PostgreSQL 15.0 with PostGIS 3.3.3.
I have total 36 layers which contained in 3 groups: A, B, C. Now X user has read only access on all layers ...
3
votes
1
answer
97
views
Find all geometries in one table that do not exist in another
Using PostgreSQL and PostGIS, I have two tables of polygons, and I need to know which of the records in table p1 do not exist in table p2. I do not have additional information available (e.g. ids) - ...
0
votes
1
answer
282
views
Prevent sending too many requests while zooming/paning (OpenLayers 6.15)
I have a web page that displays WMS data from a WMS server, using a TileLayer. The images are fetched with a callback function called by the setTileLoadFunction(..) method of the associated TileWMS ...
3
votes
0
answers
140
views
Speed up a query using ST_Within and ST_PointOnSurface
CREATE TABLE municipal_area (
id varchar NOT NULL,
"name" varchar NOT NULL,
state_id varchar NOT NULL,
state_abbr varchar NOT NULL,
state_name varchar NOT NULL,
...