Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.ruby > #3700 > unrolled thread

Beginner - please help me to solve this issue

Back to article view | Back to comp.lang.ruby

Contents

  Beginner - please help me to solve this issue "Naina A." <naina.sydney@gmail.com> - 2011-04-29 10:12 -0500
    Re: Beginner - please help me to solve this issue "Naina A." <naina.sydney@gmail.com> - 2011-04-29 17:14 -0500

#3700 — Beginner - please help me to solve this issue

Any idea why DB time is more here? Please help me how can I proceed
further in solving the issue..

Completed in 0.19635 (5 reqs/sec) | Rendering: 0.00046 (0%) | DB:
0.04554 (23%) | 200 OK

Completed in 0.00470 (212 reqs/sec) | Rendering: 0.00070 (14%) | DB:
0.02763 (587%) | 200 OK

Completed in 0.00507 (197 reqs/sec) | Rendering: 0.00079 (15%) | DB:
0.03448 (679%) | 200 OK

Completed in 0.00651 (153 reqs/sec) | Rendering: 0.00097 (14%) | DB:
0.03318 (509%) | 200 OK

Completed in 0.00478 (209 reqs/sec) | Rendering: 0.00085 (17%) | DB:
0.05701 (1193%) | 200 OK

I have checked the benchmark.rb file  and below is how it is
calculating.
def active_record_runtime(runtime) db_runtime =
ActiveRecord::Base.connection.reset_runtime db_runtime +=
@db_rt_before_render if @db_rt_before_render db_runtime +=
@db_rt_after_render if @db_rt_after_render db_percentage = db_runtime *
100 / runtime " | DB: %.5f (%d%%)" % [db_runtime, db_percentage.to_i]
end

-- 
Posted via http://www.ruby-forum.com/.

[toc] | [next] | [standalone]

#3724

Okay, found the answer. We are using Solr, and frontend is querying solr 
which is converting the mysql query and taking a lot of time to run.

-- 
Posted via http://www.ruby-forum.com/.

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.ruby

csiph-web