This content has been marked as final. Show 5 replies
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.
In addition to Simon's remarks: The topology must have been created from something, one would expect from another table containing SDO_GEOMETRY. Can you use that table instead?
takes 8 seconds on local machineIs that machine comparable to a proper server? In other words: it may run faster if Oracle has more computing power to use.
Edited by: Stefan Jager on Feb 21, 2013 3:38 PM
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.