Performance issues

[jdandriessen]

I am currently running a test with Pygeoapi for a development team, as they would like to display some data on a map.
I am running into two issues and was wondering if you might have some tips.

Problem 1
I currently have Pygeoapi running locally in a Docker environment. The PostgreSQL database (with PostGIS) is also running locally in Docker. See the configuration below.
However, the data is rendered very slowly on the map, which makes it unusable in practice. I suspect this has to do with my configuration — do you have any suggestions to improve this? I use ArcGIS Maps SDK for Javascript to display the data.

Docker file

    FROM geopython/pygeoapi:latest
    RUN pip install --break-system-packages --no-cache-dir -r /pygeoapi/requirements-starlette.txt

Docker-compose

    backend-pygeoapi:
          build:
              context: ./backend  
          container_name: backend-pygeoapi
          volumes:
            - ./backend/config.yml:/pygeoapi/local.config.yml
            - ./backend/_base.html:/pygeoapi/pygeoapi/templates/_base.html
            - ./backend/landing_page.html:/pygeoapi/pygeoapi/templates/landing_page.html
          ports:
            - "5000:80"
          environment:
            - WSGI_APP=pygeoapi.starlette_app:APP
            - WSGI_WORKER_CLASS=uvicorn.workers.UvicornH11Worker
            - WSGI_WORKERS=8
          command: run
          depends_on:
            db-postgres:
              condition: service_healthy
          networks:
            - geo_service_netwerk

Pygeoapi config

  server:
      bind:
          host: 0.0.0.0
          port: 5000
      url: http://localhost:5000
      mimetype: application/json; charset=UTF-8
      encoding: utf-8
      gzip: false
      languages:
          # First language is the default language
          - en-US
      cors: true
      pretty_print: true
      limits:
          default_items: 1000

    resources:
        afsluiter:
            type: collection
            title:
                en: Afsluiter
            description:
                en: Afsluiters
            keywords:
                en:
                    - Afsluiter
            extents:
                spatial:
                    bbox: [3.37,50.75,7.21,53.47]
                    crs: http://www.opengis.net/def/crs/OGC/1.3/CRS84
            providers:

          - type: feature
            name: PostgreSQL
            data:
                host: db-postgres
                port: 5432
                dbname: data
                user: .
                password: .
                search_path: [data]
            id_field: ID
            table: afsluiter
            geom_field: geometry
            crs:
              - http://www.opengis.net/def/crs/OGC/1.3/CRS84
              - http://www.opengis.net/def/crs/EPSG/0/4326
              - http://www.opengis.net/def/crs/EPSG/0/3857
              - http://www.opengis.net/def/crs/EPSG/0/4258
              - http://www.opengis.net/def/crs/EPSG/0/28992
            storage_crs: http://www.opengis.net/def/crs/EPSG/0/28992

          - type: tile
            name: MVT-postgresql
            data:
                host: db-postgres
                port: 5432
                dbname: data
                user: .
                password: .
                search_path: [data]
            id_field: ID
            table: afsluiter
            geom_field: geometry
            storage_crs: http://www.opengis.net/def/crs/EPSG/0/28992
            crs:
              - http://www.opengis.net/def/crs/OGC/1.3/CRS84
              - http://www.opengis.net/def/crs/EPSG/0/4326
              - http://www.opengis.net/def/crs/EPSG/0/3857
              - http://www.opengis.net/def/crs/EPSG/0/4258
              - http://www.opengis.net/def/crs/EPSG/0/28992
            options:
                zoom:
                    min: 0
                    max: 20
            format:
                name: pbf
                mimetype: application/vnd.mapbox-vector-tile

Problem 2
In addition, I can’t get the tiles (MVT) to work properly. I suspect this might be related to the coordinate reference system being used, but I’m not entirely sure. The data is in RD.
I actually wanted to use the tiles to improve the performance issues from problem 1. Below is an error message I get when accessing the tiles:

Error Message
backend-pygeoapi | [2025-10-09T16:27:24Z] {/pygeoapi/pygeoapi/api/init.py:589} ERROR - identifier not found
backend-pygeoapi | [2025-10-09T16:27:24Z] {/pygeoapi/pygeoapi/api/init.py:608} ERROR - HTTP 204 detected, suppressing content