Establish_connection is slow

Rails
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

2

On 23 May 2016 10:05 p.m., “saurabh verma” removed_email_address@domain.invalid
wrote:

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)
establish_connection(“#{Rails.env}”)

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

–
You received this message because you are subscribed to the Google G.
“Ruby on Rails: Talk” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to removed_email_address@domain.invalid.
To post to this group, send email to removed_email_address@domain.invalid.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rubyonrails-talk/be80bab3-a44e-40ae-9eb8-04335df5fed8%40googlegroups.com
.