1

I am using (MYSQL Workbench 8.0). When I execute the first query (simple select query). It takes too long (1 minute 15 seconds on average) to execute that query. After the first successful attempt, it works fine.

Additional Info: My database is on AWS (Amazon Web Services) and it is a private database.

Simple Query like:

SELECT * FROM DATABASE_TABLE LIMIT 1;

I read other sources but unable to find the right answer.

Additional Resources:

mysql query taking too long to execute

Amazon RDS MySQL instance performs very slow MySQL query is the very slow first time to run

Mr-Faizan
  • 1,179
  • 1
  • 8
  • 9
  • First time to run query has many 'one-time' housekeeping duties to complete the first query. What are you calling too long? 2 seconds or 20 seconds? How many tables are available to the instance? How many indexes are available to the instance? Each one takes time. – Wilson Hauck Jan 19 '21 at 14:05

0 Answers0