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?
Subject: Remove Server speed compared to Local Server
Date: Sun, 1 Jun 2008 13:41:21 +0100
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-Trace: 1 Jun 2008 06:36:16 -0700, 184.108.40.206
Xref: solutions.advantagedatabase.com Advantage.Networking:752
Article PK: 1132171
Subject: Re: Remove Server speed compared to Local Server
Content-Type: text/plain; charset=iso-8859-1
Date: 2 Jun 2008 02:41:47 -0700
X-Trace: 2 Jun 2008 02:41:47 -0700, 220.127.116.11
Xref: solutions.advantagedatabase.com Advantage.Networking:753
Article PK: 1132172
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
> 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).
System Consultant (Advantage Database Server)