Hi Sven, I ran into a couple of performance issues with PostGIS / OGC Features API, see:
https://github.com/MapServer/MapServer/pull/7198 https://github.com/MapServer/MapServer/pull/7197 So maybe try setting the type for your ID field, and wfs_use_default_extent_for_getfeature. If you are using MapServer 8.4 they might help. Seth -- web:https://geographika.net & https://mapserverstudio.net mastodon: @geographika@mastodon.social On Wed, Apr 9, 2025, at 11:52 AM, Schroeter via MapServer-users wrote: > Hi Jukka, > > Thank you very much, that was the solution for QGIS. > I now also have an interim solution for performance. > I have exported the table as a geopackage and connected it, and lo and > behold, everything runs very quickly: > https://kulturdb.de/cgi-bin/mapserv/kdb_ogcapi/ogcapi/collections/kdb_alle/items?f=json&limit=10000 > Since my queries to the Postgis table also run very quickly via PHP, it can't > really be the Postgis DB. Is the performance problem in MS with Postgis a bug? > > Greetings > > Sven Schröter > > ************************************** > NETGIS GbR > Benediktinerstr. 32a > 54292 Trier > Tel.: 0651-1704731 > Fax: 0651-1704733 > schroe...@netgis.de > www.netgis.de > > > Am 09.04.2025 um 11:03 schrieb Rahkonen Jukka: >> The URL to use for the connection is the URL of the landing page >> >> https://kulturdb.de/cgi-bin/mapserv/kdb_ogcapi/ogcapi/ >> >> That link opens as http on a browser but QGIS knows how to read the document >> as JSON. >> >> -Jukka Rahkonen- >> >> ________________________________________ >> Lähettäjä: MapServer-users käyttäjän Schroeter via MapServer-users puolesta >> Lähetetty: Keskiviikko 9. huhtikuuta 2025 11.50 >> Vastaanottaja: mapserver-users@lists.osgeo.org >> Aihe: Re: [MapServer-users] OGCAPI >> >> >> Hello Jörg, >> >> thanks for the answer, strangely enough Qgis (version 3.4) is still >> stubbornly trying to send me a WFS request. I have now also cleared the >> cache and explicitly set OGC-Api. The wrong request is always set in the >> diagnostic tools. Which url do you enter as the source in Qgis? Have you >> ever created a service with > 40,000 objects? >> >> Sven >> >> >> >> >> >> Am 09.04.2025 um 09:28 schrieb Jörg Thomsen (WhereGroup) via >> MapServer-users: >> >>> Hello Sven, >>> >>> somehow qgis tried to use a wfs-request. I had to configure your >>> service explizit as OGC-Api (not "Maximum") and delete the cache in >>> QGIS. Now I can use both collections. >>> >>> The kdb_alle works not for all items, I have tried up to 10.000 (in >>> QGIS with checkbox 'only load items i curent mapxtent'. >>> >>> https://kulturdb.de/cgi-bin/mapserv/kdb_ogcapi/ogcapi/collections/kdb_alle/items?f=json&limit=10000 >>> >>> >>> Don't know what ist happening, perhaps the MapServer log can tell you >>> more. >>> >>> Jörg >>> >>> Am 08.04.25 um 17:56 schrieb Schroeter via MapServer-users: >>> >>>> Hi all, >>>> >>>> I am currently testing the ogcapi function in the current Mapserver >>>> 8.4 and already have an example online: >>>> https://kulturdb.de/cgi-bin/mapserv/kdb_ogcapi/ogcapi/collections?f=html >>>> In the first collection, all objects (approx. 48,000 point objects >>>> from a Postgis DB) are queried. Unfortunately extremely slow. >>>> If I query all objects via a WMS, they come very quickly, it should >>>> not be due to the DB or the connection, everything is cleanly indexed >>>> etc.: >>>> https://kulturdb.de/cgi-bin/mapserv?map=kdb&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&BBOX=49.49%2C6.0739%2C50.4%2C7.296&CRS=EPSG%3A4326&WIDTH=762&HEIGHT=588&LAYERS=kdb_alle&STYLES=&FORMAT=image%2Fpng >>>> >>>> >>>> With the second collection with only 333 objects, it works quite well: >>>> https://kulturdb.de/cgi-bin/mapserv/kdb_ogcapi/ogcapi/collections/kdb_brunnen/items?f=html >>>> >>>> >>>> Here is the map file for it >>>> >>>> MAP >>>> NAME "kdb_trier" >>>> STATUS ON >>>> SIZE 400 400 >>>> EXTENT 6.074 49.492 7.296 50.435 >>>> UNITS METERS >>>> >>>> PROJECTION >>>> "init=epsg:4326" >>>> END >>>> >>>> WEB >>>> METADATA >>>> # OGC API Features Konfiguration >>>> "ows_enable_request" "*" >>>> "ows_getfeatureinfo_formatlist" >>>> "text/plain,text/html,application/json,application/vnd.ogc.gml,gml" >>>> "oga_onlineresource" >>>> "https://kulturdb.de/cgi-bin/mapserv/kdb_ogcapi/ogcapi"; >>>> "oga_title" "KDB Trier" >>>> "oga_abstract" "Objekte der >>>> Kulturdatenbank der Region Trier" >>>> "oga_srs" "EPSG:25832 EPSG:4326 >>>> EPSG:3857" >>>> "oga_html_template_directory" >>>> "/var/www/html/ogcapi/templates/html-bootstrap4/" >>>> "oga_extent" "6.074 49.492 7.296 >>>> 50.435" >>>> "oga_use_default_extent_for_getfeature" "true" >>>> "oga_limit_default" "10" >>>> "oga_limit_max" "500" >>>> "oga_paging" "true" >>>> "oga_paging_linkheader" "true" >>>> "gml_include_items" "all" >>>> "gml_featureid" "lfdnr" >>>> END >>>> >>>> TEMPLATE "/var/www/mapserver/template/dummy.html" >>>> >>>> END >>>> >>>> OUTPUTFORMAT >>>> NAME "png" >>>> DRIVER AGG/PNG >>>> MIMETYPE "image/png" >>>> IMAGEMODE RGB >>>> EXTENSION "png" >>>> FORMATOPTION "GAMMA=0.75" >>>> END >>>> >>>> OUTPUTFORMAT >>>> NAME "application/json" >>>> DRIVER "OGR/GEOJSON" >>>> MIMETYPE "application/json" >>>> FORMATOPTION "FORM=SIMPLE" >>>> FORMATOPTION "STORAGE=memory" >>>> END >>>> >>>> SYMBOL >>>> NAME "circle" >>>> TYPE ELLIPSE >>>> POINTS >>>> 1 1 >>>> END >>>> FILLED TRUE >>>> END >>>> >>>> LAYER >>>> NAME "kdb_alle" >>>> TYPE POINT >>>> STATUS ON >>>> INCLUDE "_connection_kdb.inc" >>>> DATA "the_geom FROM kdb_kultur_ogr USING UNIQUE lfdnr" >>>> PROJECTION >>>> "init=epsg:4326" >>>> END >>>> >>>> METADATA >>>> >>>> # OGC API Features Metadaten >>>> "oga_title" "KDB Trier - alle >>>> Objekte" >>>> "oga_description" "Alle Objekte der >>>> Kulturdatenbank der Region Trier" >>>> "oga_id_field" "lfdnr" >>>> "oga_queryable" "true" >>>> "oga_extent" "6.074 49.492 7.296 >>>> 50.435" >>>> "ows_title" "KDB Trier - alle >>>> Objekte" >>>> "ows_abstract" "Alle Objekte der >>>> Kulturdatenbank der Region Trier" >>>> "oga_extent" "6.074 49.492 7.296 >>>> 50.435" >>>> "oga_use_default_extent_for_getfeature" "true" >>>> "oga_limit_default" "10" >>>> "oga_limit_max" "500" >>>> "oga_paging" "true" >>>> "oga_paging_linkheader" "true" >>>> "gml_include_items" "all" >>>> "gml_featureid" "lfdnr" >>>> >>>> END >>>> >>>> TEMPLATE "/var/www/mapserver/template/dummy.html" >>>> >>>> CLASS >>>> NAME "KDB" >>>> STYLE >>>> SYMBOL "circle" >>>> SIZE 6 >>>> COLOR 255 0 0 >>>> OUTLINECOLOR 255 255 255 >>>> END >>>> END >>>> END # LAYER >>>> >>>> >>>> LAYER >>>> NAME "kdb_brunnen" >>>> TYPE POINT >>>> STATUS ON >>>> INCLUDE "_connection_kdb.inc" >>>> DATA "the_geom FROM (SELECT * FROM kdb_kultur_ogr WHERE b_kateg >>>> = 'Brunnen') AS foo USING UNIQUE lfdnr" >>>> PROJECTION >>>> "init=epsg:4326" >>>> END >>>> >>>> METADATA >>>> >>>> # OGC API Features Metadaten >>>> "oga_title" "KDB Trier - Brunnen" >>>> "oga_description" "Brunnen Objekte der >>>> Kulturdatenbank der Region Trier" >>>> "oga_id_field" "lfdnr" >>>> "oga_queryable" "true" >>>> "oga_extent" "6.074 49.492 7.296 >>>> 50.435" >>>> "ows_title" "KDB Trier - Brunnen" >>>> "ows_abstract" "Brunnen Objekte >>>> der Kulturdatenbank der Region Trier" >>>> "oga_extent" "6.074 49.492 7.296 >>>> 50.435" >>>> "oga_use_default_extent_for_getfeature" "true" >>>> "oga_limit_default" "10" >>>> "oga_limit_max" "500" >>>> "oga_paging" "true" >>>> "oga_paging_linkheader" "true" >>>> "gml_include_items" "all" >>>> "gml_featureid" "lfdnr" >>>> >>>> END >>>> >>>> TEMPLATE "/var/www/mapserver/template/dummy.html" >>>> >>>> CLASS >>>> NAME "KDB" >>>> STYLE >>>> SYMBOL "circle" >>>> SIZE 6 >>>> COLOR 255 0 0 >>>> OUTLINECOLOR 255 255 255 >>>> END >>>> END >>>> END # LAYER >>>> >>>> >>>> END # MAP >>>> >>>> THE MS Version: >>>> MapServer version 8.4.0 PROJ version 9.1 GDAL version 3.6 OUTPUT=PNG >>>> OUTPUT=JPEG OUTPUT=KML SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE >>>> SUPPORTS=CAIRO SUPPORTS=ICONV SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT >>>> SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER >>>> SUPPORTS=SOS_SERVER SUPPORTS=OGCAPI_SERVER SUPPORTS=FASTCGI >>>> SUPPORTS=THREADS SUPPORTS=GEOS INPUT=JPEG INPUT=POSTGIS INPUT=OGR >>>> INPUT=GDAL INPUT=SHAPEFILE INPUT=FLATGEOBUF >>>> >>>> 1. How can I speed up the display for the first collection? >>>> 2. the collections are not recognised in QGIS, What ist wrong? >>>> >>>> Thanx >>>> Sven >>>> >>>> >>>> >>>> >>>> >>>> _______________________________________________ >>>> MapServer-users mailing list >>>> MapServer-users@lists.osgeo.org >>>> https://lists.osgeo.org/mailman/listinfo/mapserver-users >>>> >>> >> _______________________________________________ >> MapServer-users mailing list >> MapServer-users@lists.osgeo.org >> https://lists.osgeo.org/mailman/listinfo/mapserver-users >> >> >> > > _______________________________________________ > MapServer-users mailing list > MapServer-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/mapserver-users >
_______________________________________________ MapServer-users mailing list MapServer-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapserver-users
