st_geometry performance

02-17-2017 09:38 AM
New Contributor III

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

0 Kudos
1 Reply