I'm using geoserver 2.9.0 with the oracle plugin and try to publish a layer
of a view. I created the View in the database and in Geosever (add new layer
-> create view) with the same results.
The original table in the database has a spatial index and publishing the
table directly works fine. If i use any kind of view, the spatial index of
the table seems to be ignored. Even the computation of the Bounding Box
takes ~30 minutes (with an index ~15 seconds).
Does anyone else have the same problem? Any suggestions how to solve this
problem? Creating materialized views for each table is no option for me
since i'm running out of table space.
If the view makes simple "SELECT geometry, other_stuff WHERE..." the spatial index works transparently for us. We do not run 2.9, though. Do you use some more advanced SQL in your views? Also giving GRANT SELECT ON VIEW for the geoserver user may not be enough but your user seems to have good rights because normat tables work fine.
I'm using geoserver 2.9.0 with the oracle plugin and try to publish a layer
of a view. I created the View in the database and in Geosever (add new layer
-> create view) with the same results.
The original table in the database has a spatial index and publishing the
table directly works fine. If i use any kind of view, the spatial index of
the table seems to be ignored. Even the computation of the Bounding Box
takes ~30 minutes (with an index ~15 seconds).
Does anyone else have the same problem? Any suggestions how to solve this
problem? Creating materialized views for each table is no option for me
since i'm running out of table space.
------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity planning
reports.http://sdm.link/zohodev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users