[postgis-tickets] [PostGIS] #4672: Cache the return value for getSRSbySRID per transaction

[PostGIS]

#4672: Cache the return value for getSRSbySRID per transaction
--------------------------+---------------------------
  Reporter:  Raúl Marín   |      Owner:  pramsey
      Type:  enhancement  |     Status:  new
  Priority:  medium       |  Milestone:  PostGIS 3.1.0
 Component:  postgis      |    Version:  master
Resolution:               |   Keywords:
--------------------------+---------------------------

Comment (by Raúl Marín):

 PR: https://github.com/postgis/postgis/pull/557


 I've removed the srs calculation from ST_AsX3D since it was never used.

 For a point dataset (same srs for all rows) this greatly improves the
 performance:
 - ST_AsGML: 20x
 - ST_AsX3D: 90x
 - ST_AsGeoJSON (with srs options): 40x

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4672#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.