switch takes ages

[gshilin]

I've got around 400,000 users and switch takes ages.
It also tries to load all of these users into memory.
Any ideas?

[sergey-alekseev]

@gshilin have you encountered memory issues like Cannot allocate memory - identify?

[flyerhzm]

@gshilin @sergey-alekseev on README, I mentioned "If there are too many users (on production), the switch_user_select is not a good choice, you should call the switch user request by yourself.", you can build an input text field, fuzzy search users by ajax, then call the switch user request.

[gshilin]

I don't use switch_user_select. The problem is in switch_user_controller#handle_request where the following line

record = SwitchUser.data_sources.find_scope_id(params[:scope_identifier])

loads ALL users.
I'm on Rails 4.2 and ruby 2.2.2

[Whitespace]

+1, this generates a SELECT "users".* FROM "users" WHERE "users"."deleted_at" IS NULL for us

[flyerhzm]

it should already be fixed in master branch, could you try it?

[gshilin]

Yes, it works now, thank you