Trolltech Home | Qt-interest Home | Recent Threads | All Threads | Author | Date
All threads index page 7

Qt-interest Archive, March 2002
RE QSql

• Subject: RE QSql
• From: Popeanga Marian <pmarian@xxxxxxx>
• Date: Tue, 19 Mar 2002 13:44:59 +0200
• To: qt-interest@xxxxxxxxxxxxx

   I have used Qsql... classes but with very poor performance for ODBC. 
They work well when you try to connect, for ex, to dbf files. The 
diferencies when you connect with QOCI and QODBC are substancials. So if 
you can, don't using ODBC if you have specific drivers, especialy for SGBDs.

Popeanga Marian
DBA Oracle

• Subject: Re: RE QSql
• From: Harald Fernengel <harald@xxxxxxxxxxxxx>
• Date: Tue, 19 Mar 2002 14:37:21 +0100
• To: qt-interest@xxxxxxxxxxxxx

Hi,

On Tuesday 19 March 2002 12:44, Popeanga Marian wrote:
>    I have used Qsql... classes but with very poor performance for ODBC.
> They work well when you try to connect, for ex, to dbf files. The
> diferencies when you connect with QOCI and QODBC are substancials. So if
> you can, don't using ODBC if you have specific drivers, especialy for
> SGBDs.

Speed heavily depends on the speed of the ODBC driver. With Oracle ODBC driver 
you have about one second penalty to describe a table, on other drivers the 
same call is lightning fast. We implemented table structure caching for the 
next release of the QODBC plugin to limit all calls to the ODBC driver, this 
will bring quite a speed-up for some ODBC drivers.

Best regards,
Harald