Select to view content in your preferred language

Time for st_AsText for complex features

10-21-2020 06:25 AM
Esri Regular Contributor

Hello all

We are trying to translate some geometries in Oracle to WKT using st_AsText

It takes a long tome for complex features.

For example a polygon with 31k points was translated into 600k WKT string in 25 seconds.

Does this reasonable time? Is there any tuning in the database or Geodatabase that can make this faster?


0 Kudos
3 Replies
Esri Notable Contributor

You may want to work with Technical Support on this issue to help determine where the bottle neck may be.

What is the version of Oracle (include the O/S that it is on) and the version that the Geodatabase it at?

What happens when the polygon has less or more vertexes? Is the performance different.

--- George T.
Esri Regular Contributor

Hi George

Thanks for the response.

Technical support might say this is ok so I first need to understand if it is reasonable.

I hope if somebody has a polygon with more then 10k vertexes they can test it in 3 minutes.

It is a Linux (Red Hut) machine that runs Geodatabase 10.7.1 

The time is changing by the polygon (not sure if it is linear). This is just some countries borders but very detailed.

The border of Russia have many more vertexes and takes for ever.


0 Kudos
Esri Esteemed Contributor

Unfortunately, that performance is about what I've seen (it's truly awful with 6.1M vertices).  I did some benchmarking, and found I could improve performance by 40-60 percent *and* reduce the size of the resulting string by 20-30%, but only by using 'C' language functions at the lowest level of the component libraries.  The fix would require rewriting the low-level WKT function.

- V

0 Kudos