Alpha Video Training
Results 1 to 4 of 4

Thread: A4v6 and VPN

  1. #1
    Joe Goodson

    Default A4v6 and VPN

    Has anyone tried A4v6 over VPN? I am currently setting up a cross-town connection from a 256k T1 fraction frame relay to a DSL router using a firewall and VPN tunneling. Accessing a small database of 8 fieldsis relatively fast, but a set with 150 fields is slow. Very slow. Any suggestions on how to speed things up?

  2. #2
    Ray Fernandez

    Default RE: A4v6 and VPN


    Using A4 with VPN is not the issue here. VPN will work just fine with A4. The problem is A4 is NOT a client server structure; all records will need to be transmitted to your client machine over your VPN line.


    If a table has over 80,000 rows (records) and you'll need only 10 records, all 80,000 rows will be transferred to your client machine and all queries will be done locally. This is why it's so slow. I've experimented with Microsoft ADO components using A4 tables. I specifically specify only 10 records, all 80,000 rows (records) were transferred to my local machine and then a query was run locally to return 10 records.

    The only way you're gonna get speed is in a client server environment. This is the only way that all queries are done at the server and only those records that you need, are transmitted to you at the client.

    I think Alpha 5 if going to start using the “codebase” client server structure soon.

    Hope this helps.
    RF - ARS Motorola

  3. #3
    Joe Goodson

    Default RE: A4v6 and VPN

    Thanks Ray,
    It is helpful to know that ADO is a blind alley for A4v6. The most consistant advice I've received to date is to use remote application serving such as a Citrix server. That's not a path we want to pursue, but alas, the choices may be few.

  4. #4
    John Leach

    Default RE: A4v6 and VPN

    Set up MS Terinal server on the Server that is controling the vpn. When you log into the Terminal server the only thing that is transmitted to you is the screen and keystokes that you send back.

Similar Threads

  1. A4V6.0.0 to A4V6.2
    By Robert Lundquist in forum Alpha Four Version 6 and Prior
    Replies: 3
    Last Post: 12-06-2003, 01:03 PM
  2. A4V6
    By Brad Statler in forum Alpha Four Version 6 and Prior
    Replies: 2
    Last Post: 11-06-2003, 08:21 AM
  3. A4V6 & Win ME
    By tadraw in forum Alpha Four Version 6 and Prior
    Replies: 5
    Last Post: 11-19-2002, 05:04 AM
  4. H E L P A4v6 .2!
    By Ken L Herrold in forum Alpha Five Version 4
    Replies: 3
    Last Post: 03-28-2002, 11:17 AM
  5. A4V6 Help.DBF?
    By Bill Abraham in forum Alpha Four Version 6 and Prior
    Replies: 1
    Last Post: 12-28-2001, 09:01 AM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts