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
[email protected]
https://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/mapserver-users
