I would like to view a topological layer geometry using oci client. I found in docs a method named SDO_TOPO_GEOMETRY.GET_GEOMETRY that produces SDO_GEOMETRY from topological feature. But this method is very slow (converting 3600 records of simple road network takes 8 seconds on local machine). Is there a better/faster way of viewing topological features geometry using PLSQL or I have to query directly in a layer topology tables with $ postfix ?
Is it possible for you to create a materialized view over your topology layer that caches the SDO_GEOMETRY generated by SDO_TOPO_GEOMETRY.GET_GEOMETRY?
If so, look at created a materialized view log over the original table and set up the MV for fast refresh on changes.
I would not query the $ tables directly. You can spend a lot of time working out how to do this, copying what the Oracle Spatial team have done themselves, and in the end not have a solution that is any faster.
Thanks. Using a materialized view is fine. The general idea is to draw a topological layer that in next step can be edited. Then the layer must be displayed in network style (with nodes, edges, faces) so each element can be identified and modified using a mouse. Probably for this stage I will have to use $ tables.