[Geoserver-users] Layer Preview Timing Out

Hello,

I have a few layers on Geoserver. When I’m in the Layer Preview section and click the GeoJSON option from the All Formats dropdown from one of my larger datasets, the query times out.

If I pick the GeoJSON option from one of my smaller datasets, the query runs as intended.

I believe that the GeoJSON option is running a full table scan and then applies a limit after the query completes rather than running a scan with the limit included in the query.

Is this correct? And if so, is there a workaround for this?

Regards,
Vineet