Direct Mode is too slow

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
sunwya0112
Posts: 5
Joined: Sun 07 Dec 2014 04:39

Direct Mode is too slow

Post by sunwya0112 » Sun 07 Dec 2014 04:43

Don't use Direct Mode ,connect to sql server on the interent is so quickly!

After use Direct Mode ,connect to sql server on the interent is so slowly!


Just connect ,no query data !

Why?


And after connect successful ,select data is quick !

I hope you can do it better in connect speed !

azyk
Devart Team
Posts: 1058
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Direct Mode is too slow

Post by azyk » Mon 08 Dec 2014 12:44

Thank you for the information. We will investigate the reason for slow Internet connection in Direct Mode for SDAC. We will notify you about the results as soon as any are available.

vercom
Posts: 2
Joined: Thu 18 Dec 2014 01:46

Re: Direct Mode is too slow

Post by vercom » Thu 18 Dec 2014 01:55

Direct mode is very slow even on local network.
I'm sure you'll solve this asap.
Do you plan to develop http tunnel option for MSSQLSERVER like you did for mysql ?

azyk
Devart Team
Posts: 1058
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Direct Mode is too slow

Post by azyk » Fri 19 Dec 2014 09:42

We couldn't reproduce the problem. Please try to compose a small test project demonstrating the problem with low performance in a local network. Include the script for creating and filling in the tables, and send it to andreyz*devart*com.

The HTTP Tunnel feature is already added to our roadmap.

PixAndMore
Posts: 11
Joined: Mon 16 Aug 2010 04:13
Location: Holzwickede

Re: Direct Mode is too slow

Post by PixAndMore » Mon 22 Dec 2014 08:09

Hello,

here it is also very slow, it takes over five seconds to connect to the database, i only set from prAuto to prDirect. Switching back and the connection is fast...

The first thing my app does is to check the table structure and i'm using TUniMetaData for this task. While executing "Open" I get a "Not implemented yet" message form unidac :shock:

It seems the Direct Mode is not fully functional?

azyk
Devart Team
Posts: 1058
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Direct Mode is too slow

Post by azyk » Tue 23 Dec 2014 11:28

azyk wrote:here it is also very slow, it takes over five seconds to connect to the database, i only set from prAuto to prDirect. Switching back and the connection is fast...
We have reproduced the issue with slow connection to SQL Server in Direct Mode. We will investigate this behavior and inform you about the results.
azyk wrote:The first thing my app does is to check the table structure and i'm using TUniMetaData for this task. While executing "Open" I get a "Not implemented yet" message form unidac
Currently, Direct Mode for SQL Server in UniDAC and SDAC is being improved. This functionality implementation is in progress, and it will be available in one of the next versions of UniDAC and SDAC.

sunwya0112
Posts: 5
Joined: Sun 07 Dec 2014 04:39

Re: Direct Mode is too slow

Post by sunwya0112 » Fri 16 Jan 2015 07:08

Still not fixed in the latest version 7.0.2 14-Jan-15!

When can fix this problem,give us a date !

sunwya0112
Posts: 5
Joined: Sun 07 Dec 2014 04:39

Re: Direct Mode is too slow

Post by sunwya0112 » Sun 08 Feb 2015 04:41

Until this problem be fixed,The Direct Mode Under android with mssql will not be uesed!!


It is so slowly

vercom
Posts: 2
Joined: Thu 18 Dec 2014 01:46

Re: Direct Mode is too slow

Post by vercom » Wed 18 Feb 2015 16:39

Any news on this issue ?
We are now waiting for a solution since december 2014.

I've bought unidac just for use with mobile devices and now this is what is useless for the moment.

We should all ask refund as unidac isn't quite cheap to buy.

azyk
Devart Team
Posts: 1058
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Direct Mode is too slow

Post by azyk » Thu 05 Mar 2015 10:31

The problem with slow connection to the server in Direct Mode is already fixed. The fix will be included into the next SDAC build.

osmantaskiran
Posts: 15
Joined: Thu 21 Apr 2005 22:02

Re: Direct Mode is too slow

Post by osmantaskiran » Sat 14 Mar 2015 22:40

When will you release your next build?

azyk
Devart Team
Posts: 1058
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Direct Mode is too slow

Post by azyk » Tue 17 Mar 2015 12:29

The next build will be released within this month.

osmantaskiran
Posts: 15
Joined: Thu 21 Apr 2005 22:02

Re: Direct Mode is too slow

Post by osmantaskiran » Wed 18 Mar 2015 07:17

Thank you for your reply.
We are waiting it with sensation :)

osmantaskiran
Posts: 15
Joined: Thu 21 Apr 2005 22:02

Re: Direct Mode is too slow

Post by osmantaskiran » Tue 31 Mar 2015 07:02

Hi,

Your update does not released yet.

azyk
Devart Team
Posts: 1058
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Direct Mode is too slow

Post by azyk » Tue 31 Mar 2015 10:17

Release of SDAC is planned for the early April. If you want to get these fixes before the release of the next SDAC build, send your email address and license number to andreyz*devart*com - and we will send you a night build.

Post Reply