[OpenStreetMap] #4159: Relation does not show at web front end

[OpenStreetMap]

#4159: Relation does not show at web front end
----------------------+-----------------------------------------------------
  Reporter:  Kozuch   |       Owner:  rails-dev@…                
      Type:  defect   |      Status:  closed                     
  Priority:  minor    |   Milestone:                             
 Component:  website  |     Version:                             
Resolution:  wontfix  |    Keywords:                             
----------------------+-----------------------------------------------------

Comment(by amm):

 The first thing one could do is figure out where the main slow down comes
 from. Is it that a) simply the database queries are so complex that the
 retrieval from postgres takes too long. b) processing the results in rails
 takes a too long time

 If it is mainly the former, then there is indeed likely not much one can
 do short of improving the database hardware.

 In the case of the latter, moving the relation full call over from rails
 to cgimap might help significantly. For data that was cached in the db,
 moving from rails to cgimap for the map call gave nearly a ten times speed
 up. If I remember correctly, preliminary testing for the other API calls
 showed similar speed ups with moving to cgimap, conditioned on the data
 being in the db cache.

 Should this indeed be the case, then hopefully many more relations could
 be retrieved within the timeout period. It wouldn't fix it completely, as
 the timeout would still be needed to protect the server resources.

-- 
Ticket URL: <https://trac.openstreetmap.org/ticket/4159#comment:5>
OpenStreetMap <http://www.openstreetmap.org/>
OpenStreetMap is a free editable map of the whole world