Uploaded image for project: 'Qt'
  1. Qt
  2. QTBUG-4048

Sql queries are executed as prepared statements

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: P4: Low P4: Low
    • 4.6.0
    • 4.5.1
    • SQL Support
    • None

      Every Sql query is executed as a prepared statement. This can result in a performance problem, because the network traffic is doubled.

      Example:
      QSqlQuery query("SELECT true;");

      will send the following statements to the MySql server:
      Prepare [12] SELECT true
      Execute [12] SELECT true

      This is a regression from Qt 4.4, since with Qt 4.4 only this statement is sent to the server:
      Query SELECT true

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

            wallison Warwick Allison (closed Nokia identity) (Inactive)
            sanonymous Nokia Qt Support (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

                There are no open Gerrit changes