Sql speed issue

[geanni]

Hello,
I'm working on a project with QMYSQL connection to a mysql database. Everything works fine on local but when I connect to a remote server the speed is considerable slow -7 times slower. I tried to execute a simple query on both local and remote server and I get the same result - on remote it is too much slow. I tried to execute the same query to the same server/database using another mysql client (heidiSQL) and it woks in heidi very fast. I tried also with other client and I get good results, so the problem is not the internet speed connection. Do you have any idea from where this problem could be?

Thanks,
Geanni

[mcosta]

Hi,

Have you tried the native mysql client?
Qt uses native Database drivers to connect.

[geanni]

Hi,

What I have done was to build the mysql.pro project, copy the resulting dlls into the plugins directory then using a code like:
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL", "DataSource1");
db.setHostName("hostname");
db.setDatabaseName("db");
db.setUserName("usr");
db.setPassword("pass");

if (db.open())
{
       QSqlQuery q(db);
      qDebug()<<"before "<<QTime::currentTime().toString("mm:ss:zzz");
      q.prepare("select * from table...");
      q.exec&#40;&#41;;
     if(q.lastError().isValid())
     {
           qCritical()<<q.lastError().text();
     }
    qDebug()<<"after "<<QTime::currentTime().toString("mm:ss:zzz");

}

Isn't it the best way to query a mysql?

Thanks,
Geanni