QSQLDatabase

[hoshy]

hi,

if I create a QSqlDatabase, the .open() method call is extremly slow.
Does anyone know whats wrong?

best

ps.: I'm connecting on a local database

[wysota]

Please provide more details.

[hoshy]

I'm adding a database using the driver QPSQL7 :

m_db = QSqlDatabase();
...
m_db = QSqlDatabase::addDatabase(strType.c_str(), DB_NAME);
m_db.setHostName(strHostName.c_str());
m_db.setDatabaseName(strDatabaseName.c_str());
m_db.setUserName(strUserName.c_str());
m_db.setPassword(strPassword.c_str());
m_db.setPort(iPort);
...

m_db = QSqlDatabase();
...
m_db = QSqlDatabase::addDatabase(strType.c_str(), DB_NAME);
m_db.setHostName(strHostName.c_str());
m_db.setDatabaseName(strDatabaseName.c_str());
m_db.setUserName(strUserName.c_str());
m_db.setPassword(strPassword.c_str());
m_db.setPort(iPort);
...

To copy to clipboard, switch view to plain text mode 

while calling:

m_db.open();

m_db.open();

To copy to clipboard, switch view to plain text mode 

my app blocks for about two seconds

[wysota]

Does it also block for two seconds if you use psql console? Maybe your database is clogged and needs some vacuuming? How did you calculate those two seconds, by the way? Like that?

QTime t;
t.start();
m_db.open();
qDebug() << t.elapsed();

QTime t;
t.start();
m_db.open();
qDebug() << t.elapsed();

To copy to clipboard, switch view to plain text mode 

[hoshy]

Yes I did that...

I tried to vacuum the database (VACUUM tablename; ) before calling

m_db.open()

m_db.open()

To copy to clipboard, switch view to plain text mode 

But that caused a timedelay of 2,2 seconds... I have no clue whats wrong...

best,
Hoshy

[wysota]

Again, how do you calculate the delay?