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.

Sybase ASA two-tiered app performance via ODBC on WAN

5 posts in General Discussion Last posting was on 2006-06-06 13:39:18.0Z
daniel Posted on 2006-06-05 12:53:08.0Z
From: daniel <daniel@nospam.eu>
User-Agent: Thunderbird 1.5.0.2 (Windows/20060308)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Sybase ASA two-tiered app performance via ODBC on WAN
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: m168.net81-65-140.noos.fr
Message-ID: <44842889$1@forums-2-dub>
X-Original-Trace: 5 Jun 2006 05:50:17 -0700, m168.net81-65-140.noos.fr
Lines: 31
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 5 Jun 2006 05:50:19 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 5 Jun 2006 05:53:08 -0700
X-Trace: forums-1-dub 1149511988 10.22.108.75 (5 Jun 2006 05:53:08 -0700)
X-Original-Trace: 5 Jun 2006 05:53:08 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5419
Article PK: 1467

Hi all,

We are on the verge of starting the evaluation
of a typical 2-tiered application to be run
on a company intranet of an int'l corporation.

Few users (below 20) but definitely spread over
the company network.

This application - written in the 90s - runs
great on Sybase 9 or 8 servers - as well as
MS SQL server - via ODBC.

The performance on LAN has always been measured
fast and clean with subsecond response times
for most of its activity.

During the period 1998-2000, the application was
run on WANs of that time by a couple of customers
with workable but poor and un-impressive performance
ratings.

The application design is OK with clear-cut
dynamic SQL generation but ODBC definitely has
a reputation of being "kind of" talky.

Of course time has changed in this area...
What can we expect in terms of performance in
the current state of corporate intranets?

Daniel


Greg Fenton Posted on 2006-06-05 17:40:43.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Thunderbird 1.5.0.4 (Windows/20060516)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Sybase ASA two-tiered app performance via ODBC on WAN
References: <44842889$1@forums-2-dub>
In-Reply-To: <44842889$1@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: gfenton-xp.sybase.com
Message-ID: <44846bf0@forums-2-dub>
X-Original-Trace: 5 Jun 2006 10:37:52 -0700, gfenton-xp.sybase.com
Lines: 29
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 5 Jun 2006 10:37:52 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 5 Jun 2006 10:40:43 -0700
X-Trace: forums-1-dub 1149529243 10.22.108.75 (5 Jun 2006 10:40:43 -0700)
X-Original-Trace: 5 Jun 2006 10:40:43 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5420
Article PK: 1469


daniel wrote:
> The application design is OK with clear-cut
> dynamic SQL generation but ODBC definitely has
> a reputation of being "kind of" talky.
>
> Of course time has changed in this area...
> What can we expect in terms of performance in
> the current state of corporate intranets?

If the WAN is faster and more stable, then expect better performance. I
do not believe that ODBC has changed much in its "chattiness" in the
timeframe you are talking about.

However, there are lots of applications that successfully use ODBC over
a WAN. You need to determine where the slowdowns are in your
application and determine better ways of improving those. For example,
tweaking SQL Anywhere connection options (e.g. prefetch buffer, prefetch
rows) is one thing you might look at. Another would be to off load
"chatty" parts of the application into single calls (e.g. move
frequently used chatty routines into a single stored procedure).

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


daniel Posted on 2006-06-06 09:45:40.0Z
From: daniel <daniel@nospam.eu>
User-Agent: Thunderbird 1.5.0.2 (Windows/20060308)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Sybase ASA two-tiered app performance via ODBC on WAN
References: <44842889$1@forums-2-dub> <44846bf0@forums-2-dub>
In-Reply-To: <44846bf0@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: m168.net81-65-140.noos.fr
X-Original-NNTP-Posting-Host: m168.net81-65-140.noos.fr
Message-ID: <44854ec4$1@forums-1-dub>
Date: 6 Jun 2006 02:45:40 -0700
X-Trace: forums-1-dub 1149587140 81.65.140.168 (6 Jun 2006 02:45:40 -0700)
X-Original-Trace: 6 Jun 2006 02:45:40 -0700, m168.net81-65-140.noos.fr
Lines: 30
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5422
Article PK: 1470

Hi Greg,

>>What can we expect in terms of performance in

>>the current state of corporate intranets?

>If the WAN is faster and more stable, then expect
>better performance.

Kind regards for your input.

The application will be run on "trans-national"
network.

One of the issue raised by Justin Willey (on the
same question on s.p.sqlanywhere.general) is that
the application may possibly suffer from the
significantly higher latency times typically
found on int'l private networks.

I've next to no information on the subject. Can
the performance be estimated with a series of
ping measures? I'd like to avoid "citrix and al".

From the logical standpoint the application is fit
for a "replication-based" install in the sense
that these are four distinct user sets with a need
for a read-only consolidation at holding level?
Would replication be a workable option as well?

Daniel


Rob Waywell Posted on 2006-06-06 13:25:13.0Z
From: "Rob Waywell" <rwaywell_no_spam_please@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <44842889$1@forums-2-dub> <44846bf0@forums-2-dub> <44854ec4$1@forums-1-dub>
Subject: Re: Sybase ASA two-tiered app performance via ODBC on WAN
Lines: 62
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: rwaywell-xp2.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-xp2.sybase.com
Message-ID: <44858239$1@forums-1-dub>
Date: 6 Jun 2006 06:25:13 -0700
X-Trace: forums-1-dub 1149600313 10.25.98.235 (6 Jun 2006 06:25:13 -0700)
X-Original-Trace: 6 Jun 2006 06:25:13 -0700, rwaywell-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5423
Article PK: 1471

It really sounds like you need to test it. Increases in WAN bandwidth may
help you, but at the end of the day the speed of an electron hasn't changed
so the best case round trip times for the client to talk to the server won't
have changed either.

Implementing 4 'regional' servers and then consolidating data through
one-way replication up to a consolidated reporting server would be an option
worth considering, but I'd do the performance test first before starting the
replication project.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

"daniel" <daniel@nospam.eu> wrote in message news:44854ec4$1@forums-1-dub...
> Hi Greg,
>
> >>What can we expect in terms of performance in
> >>the current state of corporate intranets?
>
> >If the WAN is faster and more stable, then expect
> >better performance.
>
> Kind regards for your input.
>
> The application will be run on "trans-national"
> network.
>
> One of the issue raised by Justin Willey (on the
> same question on s.p.sqlanywhere.general) is that
> the application may possibly suffer from the
> significantly higher latency times typically
> found on int'l private networks.
>
> I've next to no information on the subject. Can
> the performance be estimated with a series of
> ping measures? I'd like to avoid "citrix and al".
>
> From the logical standpoint the application is fit
> for a "replication-based" install in the sense
> that these are four distinct user sets with a need
> for a read-only consolidation at holding level?
> Would replication be a workable option as well?
>
> Daniel


daniel Posted on 2006-06-06 13:39:18.0Z
From: daniel <daniel@nospam.eu>
User-Agent: Thunderbird 1.5.0.2 (Windows/20060308)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Sybase ASA two-tiered app performance via ODBC on WAN
References: <44842889$1@forums-2-dub> <44846bf0@forums-2-dub> <44854ec4$1@forums-1-dub> <44858239$1@forums-1-dub>
In-Reply-To: <44858239$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: m168.net81-65-140.noos.fr
Message-ID: <448584d4$1@forums-2-dub>
X-Original-Trace: 6 Jun 2006 06:36:20 -0700, m168.net81-65-140.noos.fr
Lines: 22
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 6 Jun 2006 06:36:22 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 6 Jun 2006 06:39:18 -0700
X-Trace: forums-1-dub 1149601158 10.22.108.75 (6 Jun 2006 06:39:18 -0700)
X-Original-Trace: 6 Jun 2006 06:39:18 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5424
Article PK: 1472


Rob Waywell wrote:
> It really sounds like you need to test it. Increases in WAN bandwidth may
> help you, but at the end of the day the speed of an electron hasn't changed
> so the best case round trip times for the client to talk to the server won't
> have changed either.
>
> Implementing 4 'regional' servers and then consolidating data through
> one-way replication up to a consolidated reporting server would be an option
> worth considering, but I'd do the performance test first before starting the
> replication project.

Hi Robert

Thanks. We now have the picture clear
on what we should expect.

Of course we'll test the thing soon...

Daniel.