[Geoserver-users] Omitting count(*) from WFS GetFeature request

[Carsten K. <c....@da...>]

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