[Qt-interest] QODBC seems very slow connecting to MSSQL

[Harry Sfougaris]

On 5 Ιουλ 2010, at 20:42, "Scott Aron Bloom" <Scott.Bloom at onshorecs.com> wrote:

> The TDS system is very old, and much slower than the ODBC connection...

I think this statement is only accurate when running under Windows.
All ODBC drivers I have seen under Mac and Linux are based on TDS.

And I agree odbc is slower than tds even under windows.
It was very sad for me to see Qt dropping support for it, thus leaving no decent support for MSSQL when not running under windows.

Harry


> 
> Read about its problems here.
> 
> http://labs.trolltech.com/blogs/2010/02/09/tds-driver-deprecation/
> 
> Scott
> 
> -----Original Message-----
> From: qt-interest-bounces at trolltech.com
> [mailto:qt-interest-bounces at trolltech.com] On Behalf Of Stephen Jackson
> Sent: Monday, July 05, 2010 10:15 AM
> To: Qt-interest
> Subject: Re: [Qt-interest] QODBC seems very slow connecting to MSSQL
> 
> On 5 July 2010 12:53, Roland Tollenaar wrote:
>> 
>> We seem to experience that using QODBC with QSqlQuery can be rather
> slow
>> when used with MSSQL.
>> 
>> Is there a native plugin for mssql that is faster?
>> 
>> We are using Qt 4.5.2.
>> 
>> Thanks in advance,
>> 
> 
> The native driver is TDS
> 
> qt/src/sql/drivers/tds
> 
> However, I don't know how it performs compared to ODBC.
> 
> -- 
> 
> Stephen Jackson
> _______________________________________________
> Qt-interest mailing list
> Qt-interest at trolltech.com
> http://lists.trolltech.com/mailman/listinfo/qt-interest
> 
> _______________________________________________
> Qt-interest mailing list
> Qt-interest at trolltech.com
> http://lists.trolltech.com/mailman/listinfo/qt-interest