[openstreetmap/openstreetmap-website] performance reduced when updating/migrating (#2980)

[Andy Allan]

All the lines in the "slow" log with CACHE are not actual queries to the database, so you can ignore them. You can also see that they take 0ms to run. 

But even if you take the first "Node Load" query, the queries are identical and your "slow" one takes 7.7ms and your "fast" one takes 4.3ms. For the same query. I echo Tom's suggestions of looking into your database to find out why these identical queries are taking much longer to run.

There are also plenty of things we can improve in the map call performance, when it comes to preloading data. But as Tom has also explained, this is a low priority since OSMF uses cgimap in production.

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/issues/2980#issuecomment-733598292
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20201125/e12fb956/attachment.htm>