Hello, I'm currently new to active record and exploring two map functions. I'm curious if there's a more efficient way to optimize the following query:
When I run this query, I see hundreds of lines in my terminal and worry about potential memory issues if many users access these conversations simultaneously.
Step 1: Retrieving all relevant conversations.
Step 2: Creating a conversation hash containing sender, recipient, and message information linked to each conversation.
Step 3: Sorting all conversations based on the most recent message, displaying those at the top.
EDIT 1: Rails version 5.0.1
def index
i = 1
@messages = []
@user = User.find_by(email: params[:email])
@message = Conversation.where("sender_id = ? OR recipient_id = ?", @user.id, @user.id)
@message.map { |conversation|
@messages << conversation if Message.where(conversation_id: conversation.id).count > 0
}
render json: @messages.map { |conversation|
{
date: conversation.messages.last.created_at,
sender: User.find(conversation.sender_id),
recipient: User.find(conversation.recipient_id),
conversation: {
id: conversation.id,
messages: Message.where(conversation_id: conversation.id).sort_by{|e| e[:created_at]}.reverse.map {|message| {
sender: {
email: User.find(message.user_id).email,
first_name: User.find(message.user_id).first_name,
last_name: User.find(message.user_id).last_nam },
body: message.body,
created_at: message.created_at
}
}
}}
}.sort_by { |hsh| hsh[:date] }.reverse
end