slow index action / search via ransack

rubyonrails-talk
1 

hi,
when i run my index action it takes forever to load up (www.ezhubb.com/search). how
can i speed up the mysql / rails process? i do try to limit the results, but this code is not working:
@q = MyModel.order("RAND()").limit(100).ransack(:some_field => Date.today )
@q.result(distinct: true).includes(:user).paginate(page: params[:page], per_page: 30) #.order("RAND()")

any ideas how to speed this up? ho wmany record should i pull when no search criterias
are given? everything is still on default settings (mysql, nginx etc..)
thx
2

This gem could help you rack-mini-profiler.

Cheers

3

looks promising - will try thx

4

hi,

when i run my index action it takes forever to load up (www.ezhubb.com/search). how can i speed up the mysql / rails process?

i do try to limit the results, but this code is not working: @q = MyModel.order("RAND()").limit(100).ransack(:some_field => Date.today ) @q.result(distinct: true).includes(:user).paginate(page: params[:page], per_page: 30) #.order("RAND()")

I am not an expert on this but I suspect that MyModel.order("RAND()") may be horrendously slow on a table with a large number of rows. You could see if this is the issue by removing the order clause to see if it makes a big difference.

Colin