Hey Guys,
I am running a service which has one controller action. I am connected to external db. For any db query, I am getting slow response. Looks like execution time is ok, but still there is some other delay which I am not able to figure out. When I am running this endpoint I am getting the following rails logging statement. I can understand active_record time, but don’t know the remaining response time. I also tried to get the time spend for the method function1(mentioned in the below code), which is exactly same as total time(3561 ms)
Completed 200 OK in 3561.5ms (Views: 0.3ms | ActiveRecord: 644.8ms)
Here is my code
class MyModel < ActiveRecord::Base
if Rails.env != ‘test’
establish_connection(“#{Rails.env}”)
end
class << self
def function1
self.first
end
end
end
database.yml
development:
adapter: ‘sqlserver’
mode: ‘dblib’
host: ‘MyHost’
username: ‘username’
password: ‘secret’
database: ‘MyDB’
pool: 1
Hey Guys,
I am running a service which has one controller action. I am connected to external db. For any db query, I am getting slow response. Looks like execution time is ok, but still there is some other delay which I am not able to figure out. When I am running this endpoint I am getting the following rails logging statement. I can understand active_record time, but don’t know the remaining response time. I also tried to get the time spend for the method function1(mentioned in the below code), which is exactly same as total time(3561 ms)
Completed 200 OK in 3561.5ms (Views: 0.3ms | ActiveRecord: 644.8ms)
Here is my code
class MyModel < ActiveRecord::Base
if Rails.env != ‘test’
establish_connection(“#{Rails.env}”)
end
class << self
def function1
self.first
end
end
end
database.yml
development:
adapter: ‘sqlserver’
mode: ‘dblib’
host: ‘MyHost’
username: ‘username’
password: ‘secret’
database: ‘MyDB’
pool: 1
Write a simple shell script to connect and run a query and see how long that takes. That will tell you if it is an issue connecting to the remote db
Colin
