Qt Forum

    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Unsolved

    Unsolved QODBC slow connection to an open MS Access file

    General and Desktop
    2
    6
    131
    Loading More Posts
    • 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.
    • B
      BrokenVoodooDoll last edited by

      I'm working with an MS Access file (.accdb) using QODBC driver. The file is located in a shared folder so that a lot of users can open it simultaneously. My program works fine and the connection is quite fast until someone opens that file. If that .accdb file is open on someone's computer my program starts working very slow especially considering the volume of the database (over 20 columns and 3000 rows). I've tried to connect to that file using native Windows methods (like DAO, ADO, etc) and in those cases, I don't hurdle such performance issues. I could use the Windows native mean of database connections but it would take a lot of effort and time to do that. Moreover, it'd be better to use native Qt's database connection means because they allow to quite easy use database with models and views.
      Have anyone faced such problems? Are there any ways to solve that issue?
      Thanks!

      1 Reply Last reply Reply Quote 0
      • Christian Ehrlicher
        Christian Ehrlicher Lifetime Qt Champion last edited by

        @BrokenVoodooDoll said in QODBC slow connection to an open MS Access file:

        Are there any ways to solve that issue?

        Blame the MS Access ODBC driver :)

        Qt has to stay free or it will die.

        B 1 Reply Last reply Reply Quote 0
        • B
          BrokenVoodooDoll @Christian Ehrlicher last edited by

          @Christian-Ehrlicher
          Oh yeah, I've already done this a lot of times!
          Unfortunately, I can't refuse to use MS Access. It seems to me I should learn bare C++ ODBC API.

          1 Reply Last reply Reply Quote 0
          • Christian Ehrlicher
            Christian Ehrlicher Lifetime Qt Champion last edited by

            @BrokenVoodooDoll said in QODBC slow connection to an open MS Access file:

            It seems to me I should learn bare C++ ODBC API.

            I don't understand this - how should this help you when you use ODBC when the Qt ODBC driver is using the exact same ODBC API?

            Qt has to stay free or it will die.

            B 1 Reply Last reply Reply Quote 1
            • B
              BrokenVoodooDoll @Christian Ehrlicher last edited by

              @Christian-Ehrlicher
              Well, my experience shows that when I use native Microsoft means of connection to a database, it works better than QODBC. But to tell the truth, I've tried only DAO, ADO, and OLE DB. Should try ODBC either to figure it out.

              1 Reply Last reply Reply Quote 0
              • Christian Ehrlicher
                Christian Ehrlicher Lifetime Qt Champion last edited by

                QODBC is just a wrapper around the ODBC API - so I don't expect that it magically works faster in your case then.

                Qt has to stay free or it will die.

                1 Reply Last reply Reply Quote 1
                • First post
                  Last post