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.

Remove Server speed compared to Local Server

2 posts in Networking Last posting was on 2008-06-02 09:41:47.0Z
Tim Gee Posted on 2008-06-01 12:41:21.0Z
From: "Tim Gee" <tg@dffdsfd.zzz>
Newsgroups: advantage.networking
Subject: Remove Server speed compared to Local Server
Date: Sun, 1 Jun 2008 13:41:21 +0100
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-Antivirus: avast! (VPS 080531-1, 31/05/2008), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 195.137.60.229
Message-ID: <484297c0@solutions.advantagedatabase.com>
X-Trace: 1 Jun 2008 06:36:16 -0700, 195.137.60.229
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!195.137.60.229
Xref: solutions.advantagedatabase.com Advantage.Networking:752
Article PK: 1132171

Hi,

Could someone help me with these two questions?

1. We have installed ADS (8.x) onto a 2003R2 server, and are accessing it
accross a WAN, however if we set the programs to use LOCAL instead of Remote
I'm told that it's quicker - is this likley, and if so is there a reason for
it (as I will be asked), I would suspect that its down to the number of
connectiones, i.e. ALS would be very slow with 3 connections where as ADS
would maintain its performance.

2. What would be the benefit (if any) of running Internet Server (AIS) in
this seneriao (we have a remove server with 15 clients conecting accross a
VPN, using various broadband connections), or would we be best to just try
setting the compression option on ADS?

Thanks

Tim


Joachim Duerr (ADS) Posted on 2008-06-02 09:41:47.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Remove Server speed compared to Local Server
Newsgroups: Advantage.Networking
References: <484297c0@solutions.advantagedatabase.com>
Organization: iAnywhere
User-Agent: XanaNews/1.18.1.9
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 130.214.79.11
Message-ID: <4843b24b@solutions.advantagedatabase.com>
Date: 2 Jun 2008 02:41:47 -0700
X-Trace: 2 Jun 2008 02:41:47 -0700, 130.214.79.11
Lines: 35
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!130.214.79.11
Xref: solutions.advantagedatabase.com Advantage.Networking:753
Article PK: 1132172


Tim Gee wrote in <484297c0@solutions.advantagedatabase.com>:

> 1. We have installed ADS (8.x) onto a 2003R2 server, and are
> accessing it accross a WAN, however if we set the programs to use
> LOCAL instead of Remote I'm told that it's quicker - is this likley,
> and if so is there a reason for it (as I will be asked), I would
> suspect that its down to the number of connectiones, i.e. ALS would
> be very slow with 3 connections where as ADS would maintain its
> performance.

If only one workstation accesses the files via Local Server, the
operating system will cache the whole file ... this is faster than
using Client/Server which reads record by record of the network. You
might see ADS performing faster with filters on huge tables where only
a few records pass the filter condition or with SQL spanning over
dozens of tables.
When a second user just opens the same files, with ALS you will see a
immense drop in performance, with ADS/Remote nothing should change at
all.

> 2. What would be the benefit (if any) of running Internet Server
> (AIS) in this seneriao (we have a remove server with 15 clients
> conecting accross a VPN, using various broadband connections), or
> would we be best to just try setting the compression option on ADS?

I'd use compression for AIS and connect only some users to AIS, leaving
the others on REMOTE. AIS and REMOTE don't differ a lot, but the
separation helps to use compression only for a few (the ones with a
real slow wire).

--
Joachim Duerr
System Consultant (Advantage Database Server)
Sybase iAnywhere
advantagesupport[AT]ianywhere.com