search

osm-fr / osmose-frontend

Part of osmose that shows results on the website http://osmose.openstreetmap.fr
GNU General Public License v3.0
41 stars 38 forks source link

make sure idx_marker_elem_ids is used (slow DELETE on updates) #365

Closed cquest closed 2 years ago

cquest commented 2 years ago

For errors without uuid, the DELETE only uses the source_id to find each record to be deleted. For sources with large number of errors (for example 10280), the DELETE can take more than 20s.

This PR adds a search on the marker id itself (already indexed), which brings delete times down to 36ms in my test.

cquest commented 2 years ago

Oui, j'ai vu ça après.