Question about UniDAC and Cisco AnyConnect

[invent]

Hello,

I have a performance problem using Cisco AnyConnect.

For example, I send some SQL-Statements

Code: Select all

 Complete
  13.06.2012 15:28:05 0,000 SQL Execute:  Select WERT from EINSTELLUNGEN  where BENUTZERID = '800' and TYP = 'KdSpezDBVersion'
  13.06.2012 15:28:05 0,000 SQL Execute:  select max (VERSION) from DBINFO
  13.06.2012 15:28:05 0,015 SQL Execute:  Select WERT from EINSTELLUNGEN  where BENUTZERID = '800' and TYP = 'FirmenspezifischeDLL'

You can see, that UniDac is normally very fast.

The same with Cisco AnyConnect / SQL-Server:

Code: Select all

 13.06.2012 15:25:22 0,062 SQL Execute:  Select WERT from EINSTELLUNGEN  where BENUTZERID = '800' and TYP = 'KdSpezDBVersion'
  13.06.2012 15:25:22 0,062 SQL Execute:  select max (VERSION) from DBINFO
  13.06.2012 15:25:22 0,063 SQL Execute:  Select WERT from EINSTELLUNGEN  where BENUTZERID = '800' and TYP = 'FirmenspezifischeDLL'

The same with Cisco AnyConnect / Oracle (in Direct Mode):

Code: Select all

 13.06.2012 15:34:54 0,171 SQL Execute:  Select WERT from EINSTELLUNGEN  where BENUTZERID = '800' and TYP = 'KdSpezDBVersion'
  13.06.2012 15:34:55 0,187 SQL Execute:  select max (VERSION) from DBINFO
  13.06.2012 15:34:55 0,172 SQL Execute:  Select WERT from EINSTELLUNGEN  where BENUTZERID = '800' and TYP = 'FirmenspezifischeDLL'

So, Sql-Server is slow with Cisco AnyConnect, but it's possible to work. With Oracle Direct Mode and Cisco AnyConnect my program is too slow. It's unusable.

My Questions:
- Do you have any experience with Cisco AnyConnect?
- Are the times from SQL-Server and Cisco AnyConnect normal?
- Or can I set some Options in UniDAC or Cisco AnyConnect to get more speed?
- Why is UniDAC and Oracle in direct mode so very slow?

I tested this with Interbase XE, Oracle 8.0.5 and Sql Server 2008 RC2. I use Delphi 7 with UniDAC 3.50.0.13.

Thanks in advance for any help.
Kind regards,
Gerd Brinkmann
invent GmbH

[AlexP]

hello,

Operating speed can depend on the VPN throughput capacity, which is different from the local network's one. You can try to increase the speed by reducing the size of the Oracle-formed packets. In the direct mode the size of the packets is set with the help of the global variables SDU and TDU declared in the OraNet module. In the OCI mode, these variables should be set for the client and server.