ruby on rails - Slow updating record on heroku postgresql -


I have a portal app that is hosted on Harrow on their Postgre Database Add-on. I do not understand that the user is slow on updating records on the table at times, it is always slow, but it often happens in the form of just a few seconds seconds to update a simple SQL update Taken:

  App postgrass. 127285 - - [Bronce] Duration: 8601.616 MS executed; Anonymous & gt;: "User" set "Latitude" = 40.8052049006174, "Longitude" = -73.96590407672643 WHERE "Users" "Id" = 1  

I also have an index on user model:

  add_index "User DB has only 90 records, so I do not think This is happening: ", [" latitude "," longitude "], name: using" index_users_on_latitude_and_longitude ": btree  

slow due to the index update.

Enter image details here

< / Html>

Comments

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

html - CSS autoheight, but fit content to height of div -

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -