Slow mysql response query

Question

HI,
i have made a connection with java and driver mysql in eclipse,all is ok but when i try to send a request to database,the response is very slow,it take more than 1 minute.
THANKS

package connection_mysql;
import java.sql.*;

` public class Main { private static Connection connect = null; private static Statement statement = null; private static PreparedStatement preparedStatement = null; private static ResultSet resultSet = null;

 public static void main(String[] args) {
    String pilote = "com.mysql.jdbc.Driver";
    System.out.println("---------------------------");
    try{
        Class.forName(pilote);
        System.out.println("---------1------------------");
        connect = DriverManager.getConnection("jdbc:mysql://localhost/feedback?"
                  + "user=sqluser&password=sqluserpw");
        Statement statement = connect.createStatement();
        ResultSet resultSet = statement
                  .executeQuery("select * from FEEDBACK.COMMENTS");

        while(resultSet.next()){
            System.out.println("---------------------------");
            System.out.println("nom etudiant "+resultSet.getString("myuser"));
        }
    }catch(Exception e){
        System.out.print("errooor"+e);
  }

  }

  }

You might want to add a bit more to the question ... any relevant code would help. You will get a better and quicker response. — rfornal
Can you elaborate? How many records do you have in your table? Is tour query a select? If yes, are you trying to load all data at once? Can you post your code? Also, a SQLFiddle might help — BackSlash
Is this local DB or remote and what is the time to execute simple SELECT 1? — i486

Richard T Richard T · Accepted Answer · 2014-12-09T23:11:40

Database performance is predicated on schema design and the type of query being run, in addition to the amount and distribution of data in the various tables and their attributes. When you get really crazy, "out of bounds" performance, the first thing to check is that you've not done something silly like try to fetch a terrabyte of data through a super-slow link.

We'll need a LOT more information to be able to help you!

Your FIRST thing to do is try your access through the most simple tools available, like a "terminal monitor." If it performs badly there, you must look at your fundamentals.

Connection time should not be factored in with query execution time. Put time-stamps between the steps to see where the time lag is really going. Creating a new connection can be expensive though a full minute seems very excessive.

Slow mysql response query

2 Answers