[mapserver-users] Create a tileindex for WFS

[Jeff McKenna]

Great advice from Jukka.  (especially trying the exact query through the 
psql.exe commandline utility)

I still run matviews (materialized views) for a client's app, but if I 
remember correctly for speed the trick was to specifically index (in 
that matview in Postgres) the geometry as well as the specific 
columns/attributes that the MapServer WFS is returning.

Regarding your question of how to store the tileindex, I still always 
recommend storing it in a shapefile (and then indexing that for speed 
with shptree).  For speed this cannot be beaten.  But for elegance (and 
if you feel like pulling your hair out for a day) you could try storing 
that index inside Postgres, but again I do not recommend this.  It's 
your hair ha!

Hope those tips help.

And thanks for using MS4W for sharing your geo info!

-jeff




-- 
Jeff McKenna
GatewayGeo: Developers of MS4W, MapServer Consulting and Training
co-founder of FOSS4G
http://gatewaygeo.com/



On 2021-04-12 9:00 a.m., mathias cunault via mapserver-users wrote:
> Hello,
> In a PostgreSQL 13 database, I have 3 materialized views with 2578, 
> 22013 and 62500 rows.
> I am using MS4W 4.0.3 to generate a WFS based on these 3 views.
> The aim is for users to display these WFS in QGIS.
> I have other lightweight views in PostgreSQL that can be easily 
> displayed, but these 3 materialized views seem to be too heavy to 
> display because some messages say that Downloading the layer entities 
> has failed or partially failed.
> I wonder if using a tileindex was a good idea to speed up the display. 
> Before going further in the developments, I would like your opinion 
> about two things :
> 
>   * I have to cut my views in "slices" before create a tileIndex for
>     each one.
>   * The tileindex can be stored in postgis database.
> 
> Am I right?
> If not is there a better solution ?
> Thanks for your help
> 
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users
>