|
From: Carsten K. <c....@da...> - 2024-06-17 05:51:32
|
Dear all, is there a way to prevent GeoServer from issuing a count(*) on a layer's table (using PostGIS) for every GetFeature WFS request? Those tables have > 50 million rows. The query itself, which is quite simple, is very fast as it's using an index (0.1 sec). However, including the count(*) performed by GeoServer, the overall request time is ~3 secs. Any advise is highly appreciated. Carsten -- Carsten Klein Lead Software Engineer DataGis GmbH Johann-Strauß-Str. 26 70794 Filderstadt T +49 7158 9490-106 F +49 7158 9490-111 E-Mail: c....@da... Internet: www.datagis.com <http://www.datagis.com> Registergericht: Amtsgericht Stuttgart, HRB 225945 Geschäftsführung: Dr. Gunter Hahn, Markus Ruess, Carsten Klein |