[Geoserver-users] Filter a feature dataset : the best choice ?

GeoServer GeoServer User
1

Hello,

In order to improve the speed of my application which needs to interact with a big feature dataset through WFS, I would try to filter the features following a specific attribute (for example the type of a road in a road network).

To do this I see 2 solutions:

  • uses a filter in my WFS request.
  • prepares several views of my dataset with a “when” clause (I use PostGis as datastore).

Which solution will give me the fastest result ?

Cheers,

Alexandre Gacon

2

Hi Alexandre,

Others who are experts may have a better answer but I am not sure you will get one significant gain with one over the other. In the end the same predicate is being run against the data. You might pay a bit of overhead for a few but probably nothing significant. The view is nice because you dont have to worry about building the filter on the client side.

One thing to remember if you choose to use views, you have to remember to manually register is geometry column with the geometry_columns table.

-Justin

Alexandre Gacon wrote:

Hello,

In order to improve the speed of my application which needs to interact with a big feature dataset through WFS, I would try to filter the features following a specific attribute (for example the type of a road in a road network).

To do this I see 2 solutions:

- uses a filter in my WFS request.
- prepares several views of my dataset with a "when" clause (I use PostGis as datastore).

Which solution will give me the fastest result ?

Cheers,

Alexandre Gacon
!DSPAM:4007,47cfc9f676062092453641!

------------------------------------------------------------------------

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

!DSPAM:4007,47cfc9f676062092453641!

------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4007,47cfc9f676062092453641!

--
Justin Deoliveira
The Open Planning Project
jdeolive@anonymised.com