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

caleb87 notifications at github.com
Wed Nov 25 15:43:22 UTC 2020


I rsync'ed my old openstreetmap-website folder, ran it, and it finished the same area in 547ms on the new "slow" machine. On the same machine, I went back to latest OSM website folder, ran it, and it comes back 3800ms. They are both using the same database, but the latest git clone is slow. Is it possible that the latest osm website requires a configuration that's slowing it down that wasn't there before? I'm just using a default git clone on both.

@gravitystorm there are dozens of log rows that show 5-6ms. I didn't add them up. They probably don't total 3800ms though. 
`Node Load (6.2ms)  SELECT "current_nodes".* FR.....


```
New OSM website clone on new machine
Rendered api/map/index.xml.builder (Duration: 3489.9ms | Allocations: 3999549)
Completed 200 OK in 3806ms (Views: 2738.0ms | ActiveRecord: 806.8ms | Allocations: 4342985)
```

```
Old OSM website clone on new machine
Completed 200 OK in 547ms (Views: 0.1ms | ActiveRecord: 77.8ms)
```




```
OLD SERVER
About your application's environment
Rails version             5.1.5
Ruby version              2.3.1-p112 (x86_64-linux-gnu)
RubyGems version          2.5.2.1
Rack version              2.0.4
JavaScript Runtime        therubyracer (V8)
Middleware                SecureHeaders::Middleware, Rack::Sendfile, ActionDispatch::Static, ActionDispatch::Executor, ActiveSupport::Cache::Strategy::Local                                                                                                                    :Middleware, ActionDispatch::RemoteIp, Sprockets::Rails::QuietAssets, Rails::Rack::Logger, ActionDispatch::ShowExceptions, ActionDispatch::DebugExceptions,                                                                                                                     , ActionDispatch::Cookies, ActionDispatch::Session::CacheStore, ActionDispatch::Flash, Rack::Head, Rack::ConditionalGet, Rack::ETag, HttpAcceptLanguage::Mid
Application root          /home/ubuntu/openstreetmap-website
Environment               development
Database adapter          postgresql
Database schema version   20180204153242
```

```
NEW SERVER, OLD OSM CLONE THAT I RSYNC
About your application's environment
Rails version             5.1.5
Ruby version              2.7.0-p0 (x86_64-linux-gnu)
RubyGems version          3.1.2
Rack version              2.0.4
JavaScript Runtime        therubyracer (V8)
Middleware                SecureHeaders::Middleware, Rack::Sendfile, ActionDispatch::Static, ActionDispatch::Executor, Ac:Middleware, ActionDispatch::RemoteIp, Sprockets::Rails::QuietAssets, Rails::Rack::Logger, ActionDispatch::ShowExceptions, ActionDispatch::Cookies, ActionDispatch::Session::CacheStore, ActionDispatch::Flash, Rack::Head, Rack::ConditionalGet,
Application root          /home/ubuntu/openstreetmap-website
Environment               development
Database adapter          postgresql
Database schema version   20201006220807
```


```
NEW SERVER, LATEST OSM WEBSITE CLONE
About your application's environment
Rails version             6.0.3.4
Ruby version              ruby 2.7.0p0 (2019-12-25 revision 647ee6f091) [x86_64-linux-gnu]
RubyGems version          3.1.2
Rack version              2.2.3
JavaScript Runtime        Node.js (V8)
Middleware                OpenStreetMap::Cors, SecureHeaders::Middleware, ActionDispatch::HostAuthorization, Rack::Sendfile, ActionDispatch::Static, ActionDispatch::Executor, ActiveSupport::Cache::Strategy::LocalCache::Middleware, Rack::URISanitizer, Rack::Runtime, Rack::MethodOverride, ActionDispatch::RequestId, RequestStore::Middleware, ActionDispatch::RemoteIp, Sprockets::Rails::QuietAssets, Rails::Rack::Logger, ActionDispatch::ShowExceptions, ActionDispatch::DebugExceptions, BetterErrors::Middleware, ActionDispatch::ActionableExceptions, ActionDispatch::Reloader, ActionDispatch::Callbacks, ActiveRecord::Migration::CheckPending, ActionDispatch::Cookies, ActionDispatch::Session::CacheStore, ActionDispatch::Flash, ActionDispatch::ContentSecurityPolicy::Middleware, Rack::Head, Rack::ConditionalGet, Rack::ETag, Rack::TempfileReaper, I18n::JS::Middleware, HttpAcceptLanguage::Middleware, OpenStreetMap::CompressedRequests, OAuth::Rack::OAuthFilter, OmniAuth::Builder
Application root          /home/osmserver/openstreetmap-websiteNEW
Environment               development
Database adapter          postgresql
Database schema version   20201006220807
```







-- 
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-733784740
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20201125/8ebcbbf2/attachment.htm>


More information about the rails-dev mailing list