Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

SQL INSERT over Internet is slower than LAN

3 posts in General Discussion Last posting was on 2008-10-26 20:55:26.0Z
Mahinda Posted on 2008-10-26 18:29:10.0Z
Sender: 56bd.4904c236.1804289383@sybase.com
From: Mahinda
Newsgroups: ianywhere.public.general
Subject: SQL INSERT over Internet is slower than LAN
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4904c505.571e.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 26 Oct 2008 11:29:10 -0700
X-Trace: forums-1-dub 1225049350 10.22.241.41 (26 Oct 2008 11:29:10 -0700)
X-Original-Trace: 26 Oct 2008 11:29:10 -0700, 10.22.241.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7116
Article PK: 5333

I have an .NET application inserting 166 (1 X 4 (long
int)records every hour over the Internet. When this was done
over the LAN it was very fast. But over the internet it
normally takes 2.6 minutes. I am using ODBC DSN and the
Network/TCP is set to the host IP and port.

We check the latency of the connections. The PING & TRACERT
is blocked. But it takes only 2 seconds to upload 4MB file
using FTP to same. By using SpeakCheck & ATT DSL bandwidth
tools we check the download & upload speeds. They came up as
4000+bps (down) & 562bps up.

What is the difference between LAN & WAN connections in SQL
Anywhere 10?


Breck Carter [TeamSybase] Posted on 2008-10-26 19:11:53.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: ianywhere.public.general
Subject: Re: SQL INSERT over Internet is slower than LAN
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <83j9g4145sn68v9v57eohepeuacfgtetbc@4ax.com>
References: <4904c505.571e.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 26 Oct 2008 12:11:53 -0700
X-Trace: forums-1-dub 1225051913 10.22.241.152 (26 Oct 2008 12:11:53 -0700)
X-Original-Trace: 26 Oct 2008 12:11:53 -0700, vip152.sybase.com
Lines: 40
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7117
Article PK: 5340

Sadly, throughput/bandwidth and latency are two different things, and
SQL Anywhere TCP/IP latency on a WAN seriously sucks. See
http://en.wikipedia.org/wiki/Comparison_of_latency_and_bandwidth for a
discussion of the theory, and this white paper for a SQL
Anywhere-specific discussion http://www.sybase.com/detail?id=1035348
(it's a bit out of date but mostly still applicable).

Try uploading 4,096 1K files across the WAN via FTP to see the effect
of latency (and test your own patience :).

Personally, I have often whined, er, complained about the absence of
SQL-Anywhere-specific optimizations/enhancements in the area of
latency. This problem also affects proxy tables (remote database
access) as well as client server connections.

Breck

On 26 Oct 2008 11:29:10 -0700, Mahinda wrote:

>I have an .NET application inserting 166 (1 X 4 (long
>int)records every hour over the Internet. When this was done
>over the LAN it was very fast. But over the internet it
>normally takes 2.6 minutes. I am using ODBC DSN and the
>Network/TCP is set to the host IP and port.
>
>We check the latency of the connections. The PING & TRACERT
>is blocked. But it takes only 2 seconds to upload 4MB file
>using FTP to same. By using SpeakCheck & ATT DSL bandwidth
>tools we check the download & upload speeds. They came up as
>4000+bps (down) & 562bps up.
>
>What is the difference between LAN & WAN connections in SQL
>Anywhere 10?

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter@risingroad.com