[Fdo-trac] [fdo-trac] #893: MySQL Provider upgrade to use ST_INTERSECTS()

FDO trac_fdo at osgeo.org
Tue Jan 7 21:43:58 PST 2020


#893: MySQL Provider upgrade to use ST_INTERSECTS()
----------------------------+------------------------
 Reporter:  kshippey        |        Owner:  jng
     Type:  enhancement     |       Status:  reopened
 Priority:  major           |    Milestone:  3.8.0
Component:  MySQL Provider  |      Version:  3.8.0
 Severity:  3               |   Resolution:
 Keywords:  ST_INTERSECTS   |  External ID:
----------------------------+------------------------

Comment (by kshippey):

 Quick turnaround and nicely done!

 Previously, the MySQL table where I was noticing the most significant
 problem was taking over 600 seconds to query the SRID for the whole table.
 This new patch with a "LIMIT 1" is now refreshing that same layer as
 quickly as any other table or data file, so it appears entirely resolved
 now.

-- 
Ticket URL: <https://trac.osgeo.org/fdo/ticket/893#comment:7>
FDO <http://fdo.osgeo.org/>
Feature Data Objects


More information about the fdo-trac mailing list