Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. Qtsql qoci select query performance
Forum Updated to NodeBB v4.3 + New Features

Qtsql qoci select query performance

Scheduled Pinned Locked Moved General and Desktop
1 Posts 1 Posters 983 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • P Offline
    P Offline
    pateusz
    wrote on last edited by
    #1

    I've got a question performance of Qtsql module, exactly QOCI interface. Simple application which only connect and selects data, works way too slow (about 5 times) in comparison with other tools (sqldeveloper e.g). Low performance occurs on small, and big db tables.

    Pseudo code looks as follows:
    @QSqlDatabase db = QSqlDatabase::addDatabase("QOCI", "DB1");
    db.setUserName("aaa");
    db.setPassword("bbb");
    db.setDatabaseName("aaa");
    db.open();
    QSqlQuery query(db);
    query.setForwardOnly(true);
    query.prepare("select x from y where rownum < 20");
    query.setForwardOnly(true);
    db.transaction();
    query.exec();

    while (query.next()) {
    qDebug() << query.value(0).toString();
    }@

    Any suggestions how to make it faster? ps. i'm using qt 4.8.4 and ora client 11.2

    1 Reply Last reply
    0

    • Login

    • Login or register to search.
    • First post
      Last post
    0
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Get Qt Extensions
    • Unsolved