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.
< / Html>
Comments
Post a Comment