unread icon indicating copy to clipboard operation
unread copied to clipboard
verified publisher icon ledermann

Performance question with indexes

Open masudhossain opened this issue 4 years ago • 1 comments

I saw the author wrote Hint: You should add a database index on messages.created_at., which I've tried but performance is still very very slow right now.

Maybe i'm misunderstanding it. I'm suppose to add :created_at index to the messages database table, right?

Example: add_index(:messages, :created_at)

masudhossain avatar May 14 '21 05:05 masudhossain

I'm suppose to add :created_at index to the messages database table, right?

Yes.

Can you share an explain analyze of your slow query?

fatkodima avatar Oct 07 '21 13:10 fatkodima