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.

AIS Performance with increased bandwidth

2 posts in Internet Server Last posting was on 2005-06-08 21:17:41.0Z
Jason Tyldesley Posted on 2005-06-08 12:30:10.0Z
Reply-To: "Jason Tyldesley" <jason@csl-furniture.co.uk>
From: "Jason Tyldesley" <jason@csl-furniture.co.uk>
Newsgroups: advantage.internet_server
Subject: AIS Performance with increased bandwidth
Date: Wed, 8 Jun 2005 12:30:10 -0000
Lines: 16
Organization: CSL
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 80.45.11.35
Message-ID: <42a6d7e5@solutions.advantagedatabase.com>
X-Trace: 8 Jun 2005 05:35:01 -0700, 80.45.11.35
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!80.45.11.35
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:603
Article PK: 1120863

I am using advantage server with around 30 internet clients and have
recently upgraded the internet connection to the server to a 4mb direct
pipe. It runs on 2 2mb multilinked PPP lines and is fully synchronous.

The upgrade was primarily to remove a bottleneck to the server to allow the
connected clients to get improved performance. This has very strangely not
happenned. Speed has not significantly increased from the 256k upload speed
of my previous broadband connection. Are there any settings that can affect
this? Clients are Delphi programs using Tdataset descendant.

Thank you in advance

jason tyldesley


Alex Wong (ADS) Posted on 2005-06-08 21:17:41.0Z
From: "Alex Wong \(ADS\)" <alexw@extendsys.com>
Newsgroups: advantage.internet_server
References: <42a6d7e5@solutions.advantagedatabase.com>
Subject: Re: AIS Performance with increased bandwidth
Date: Wed, 8 Jun 2005 15:17:41 -0600
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 198.102.102.73
Message-ID: <42a7613c@solutions.advantagedatabase.com>
X-Trace: 8 Jun 2005 15:21:00 -0700, 198.102.102.73
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.102.102.73
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:604
Article PK: 1120866


"Jason Tyldesley" <jason@csl-furniture.co.uk> wrote in message
news:42a6d7e5@solutions.advantagedatabase.com...
>I am using advantage server with around 30 internet clients and have
> recently upgraded the internet connection to the server to a 4mb direct
> pipe. It runs on 2 2mb multilinked PPP lines and is fully synchronous.
>
> The upgrade was primarily to remove a bottleneck to the server to allow
> the
> connected clients to get improved performance. This has very strangely not
> happenned. Speed has not significantly increased from the 256k upload
> speed
> of my previous broadband connection. Are there any settings that can
> affect
> this? Clients are Delphi programs using Tdataset descendant.

The bottlenect might not be the bandwidth but the latency time while a
request travels from the client to the server and the reply goes back to the
client. If the application is very chatty, i.e. many requests/reponse
between the client and server, then this latency time will has more
significant effect than the bandwidth. In general, using SQL (TAdsQuery) to
perform updates instead of the TAdsTable will reduce the chattiness between
the client and the server. If TAdsTable is used, setting the
AdsTableOptions.AdsRecordCache to aggressive may also reduce the chattiness.

Alex