get data from sqlite database

[bibhukalyana]

Hi everyone,
I am using qt 4.7 to access sqlite database. In my database one coloum is there whic contains binary data.
My database has 5000 rows.I am using QSqlQuery to exexute query and get data from database.But for 5000 record i have to move in a loop which is time consuming .

query.record().value(0).toByteArray()

query.record().value(0).toByteArray()

To copy to clipboard, switch view to plain text mode 

Plsease tell me a better way so that i can get data within some miliseconds.

Thanks.

[kito]

You do not have to move in a loop,You can write sql statement that retrieves only data you want so that your query contains that data.

---

Added after 19 minutes:

You do not have to move in a loop,You can write sql statement that retrieves only data you want so that your query contains that data.

[bibhukalyana]

Thanks.
But my problem is i have to check some condition for each data.

[karankumar1609]

You are working with QSqlQuery :

Try this:

// EXAMPLE
    QSqlQuery query;
    QString queryString = "SELECT date FROM TABLE";
 
    query.exec(queryString);
 
    while (query.next()) {
        QSqlRecord record = query.record();
        qDebug() << "Date : " << record.value(date).toString();
    }

// EXAMPLE
    QSqlQuery query;
    QString queryString = "SELECT date FROM TABLE";

    query.exec(queryString);

    while (query.next()) {
        QSqlRecord record = query.record();
        qDebug() << "Date : " << record.value(date).toString();
    }

To copy to clipboard, switch view to plain text mode 

Hope this will help you.


CHEERS !!!

[bibhukalyana]

Yes, I am doing the same thing.But reading form QSqlQuery is time consuming.
So i want a better method for reading from database.
Or Is loading all value to an arry is the only better option for fast reading ?

[karankumar1609]

you may store your sqlRecord to QVariantList which will reduce your time to fetch data from database every time.
This will help you if you want to ONE TIME FETCH data from database.

Storing data to array will not keep the track of the data.
So store all the QSqlRecorddata in QVariantMap,
And append the Map in QVariantList ::

QVariantMap myClass::record2map(const QSqlRecord &record)
{
    QVariantMap map;
 
    for(int index = 0; index < record.count(); ++index) {
        QString key = record.fieldName(index);
        QVariant value = record.value(index);
 
        map.insert(key, value);
    }
 
    return map;
}

QVariantMap myClass::record2map(const QSqlRecord &record)
{
    QVariantMap map;

    for(int index = 0; index < record.count(); ++index) {
        QString key = record.fieldName(index);
        QVariant value = record.value(index);

        map.insert(key, value);
    }

    return map;
}

To copy to clipboard, switch view to plain text mode 

CHEERS..

!!!

[bibhukalyana]

Thanks for reply.
I tried using array.It was faster.
But i think what you suggest is better.