Initial post of draft_blurds is very slow #77

Open
betelgeuse opened this Issue Sep 23, 2012 · 2 comments

Comments

Projects
None yet
2 participants
@betelgeuse

Publishing a new project to Heroku and starting the client I get many entries like the following to the heroku log:

2012-09-23T17:50:09+00:00 heroku[router]: Error H12 (Request timeout) -> POST copycopter-instance.herokuapp.com/api/v2/projects/<key>/draft_blurbs dyno=web.1 queue= wait= service=30000ms status=503 bytes=0

The initial post seems quite slow:

2012-09-23T17:49:39+00:00 app[web.1]: Started POST "/api/v2/projects/<key>/draft_blurbs" for 1.1.1.1 at 2012-09-23 17:49:39 +0000
2012-09-23T17:49:39+00:00 app[web.1]: Processing by Api::V2::DraftBlurbsController#create as */*
2012-09-23T17:49:39+00:00 app[web.1]:   Parameters: {"project_id"=>"<key>"}
2012-09-23T17:56:33+00:00 app[web.1]: Completed 201 Created in 413551ms (Views: 0.1ms)
@opsidao

This comment has been minimized.

Show comment Hide comment
@opsidao

opsidao Feb 14, 2013

We're running on a VPS with lots of memory and still we are getting stuck by this same problem. In our case requests like the ones described here are taking up to 200 seconds to finish:

Started POST "/api/v2/projects/<project_key>/draft_blurbs" for <ip_address> at 2013-02-14 11:10:40 +0100
Processing by Api::V2::DraftBlurbsController#create as */*
  Parameters: {"project_id"=>"<project_key>"}
Completed 201 Created in 200648ms (Views: 0.1ms)

Any hints on where may this problem be coming from?

PS: FYI we have 1937145 versions for 21813 blurbs accross 12 projects, maybe we should prune old versions somehow?

opsidao commented Feb 14, 2013

We're running on a VPS with lots of memory and still we are getting stuck by this same problem. In our case requests like the ones described here are taking up to 200 seconds to finish:

Started POST "/api/v2/projects/<project_key>/draft_blurbs" for <ip_address> at 2013-02-14 11:10:40 +0100
Processing by Api::V2::DraftBlurbsController#create as */*
  Parameters: {"project_id"=>"<project_key>"}
Completed 201 Created in 200648ms (Views: 0.1ms)

Any hints on where may this problem be coming from?

PS: FYI we have 1937145 versions for 21813 blurbs accross 12 projects, maybe we should prune old versions somehow?

@opsidao

This comment has been minimized.

Show comment Hide comment
@opsidao

opsidao Feb 14, 2013

And 787041 Localizations...

opsidao commented Feb 14, 2013

And 787041 Localizations...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment