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

[Harry Sfougaris]

> Unfortunatly TDS doesn't support latest versions of MSSQL server (and
> it looks like project is dead or almost dead).
Looking at the FreeTDS mailing list it doesn't look that dead as everyone makes it out to be.
And of course it supports all version of MSSQL server; it just doesn't support some very fancy new options

> And more sadly thing is that TDS is the only MSSQL driver for other platforms than windows...
I think that is exactly the issue here. People claim TDS is dead so we should use ODBC, but all ODBC drivers (outside Windows) is based on TDS anyway....
If TDS really dies, so will all the ODBC drivers. Meanwhile, we are stuck with inefficient access to one of the world's most popular DBMS (unfortunately)... 

Harry

> 
> 
> 2010/7/5 Harry Sfougaris <hsfougaris at gmail.com>:
>> 
>> 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
>> 
>> _______________________________________________
>> 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