I just upgraded my server to AWS, and I am using RDS for database. But here, it looks like the same query is taking such a long time as compared to my old server.
I was researching and found that there is RDS cache issue. It every time calls opening table and follow all the steps and in my server it was using cache so it was not opening tables every time. I am using MySQL on RDS.
I have hundreds of thousands of records in one one table. Can someone please help me to get good performance on RDS?