st_geometry performance

RobClark3 — Fri, 17 Feb 2017 17:38:30 GMT

We are creating a materialized view from two tables via a dblink (all databases on the same server) that will process, initially, roughly 4.5 million records.

We are adding a sde.st_geometry column which constructs a point from an X and Y column in one of the tables.

Currently to create 10,000 rows it takes an hour and a half.

sde.st_geometry ('point (' || w.SOURCELON || ' ' || w.SOURCELAT || ')', 4267 )

Is that expected performance?

Removing the line that creates the spatial column and the view will create in a couple of seconds. So st_geometry is causing a huge performance bottle neck.

Oracle 11g

SDE 10.4.1

Oracle Linux 6.7

topic Re: st_geometry performance in Data Management Questions

st_geometry performance

Re: st_geometry performance