Results 1 to 4 of 4

Thread: Database applications over VPN

  1. #1
    r042wal
    Guest

    Database applications over VPN

    Why do database applications not work well over VPN? I have tried a few
    proprietary applications that are SQL driven and they are painfully slow,
    but even something as simple as ACT or QuickBooks will not work well over
    VPN. What is the reason behind this?


  2. #2
    Mike Drechsler - SPAM PROTECTED EMAIL
    Guest

    Re: Database applications over VPN

    r042wal wrote:
    > Why do database applications not work well over VPN? I have tried a few
    > proprietary applications that are SQL driven and they are painfully
    > slow, but even something as simple as ACT or QuickBooks will not work
    > well over VPN. What is the reason behind this?


    Because the latency and speed of your VPN are slower than the local LAN.
    Unless you have symmetric 100 megabit connections to the Internet for
    both locations it's just not going to be as fast as connecting on the
    local LAN.

    If your ADSL connection runs at 640Kbit/s upload and you are comparing a
    100Mbit/s LAN you can see the difference.

    100 vs 0.64. The VPN connection is up to 156 times slower.



    --
    WARNING! Email address has been altered for spam resistance.
    Please remove the -deletethispart-. section before replying directly.
    Mike Drechsler (mike-newsgroup2008@-deletethispart-.upcraft.com)

  3. #3
    Rick Merrill
    Guest

    Re: Database applications over VPN

    Mike Drechsler - SPAM PROTECTED EMAIL wrote:
    > r042wal wrote:
    >> Why do database applications not work well over VPN? I have tried a
    >> few proprietary applications that are SQL driven and they are
    >> painfully slow, but even something as simple as ACT or QuickBooks will
    >> not work well over VPN. What is the reason behind this?

    >
    > Because the latency and speed of your VPN are slower than the local LAN.
    > Unless you have symmetric 100 megabit connections to the Internet for
    > both locations it's just not going to be as fast as connecting on the
    > local LAN.
    >
    > If your ADSL connection runs at 640Kbit/s upload and you are comparing a
    > 100Mbit/s LAN you can see the difference.
    >
    > 100 vs 0.64. The VPN connection is up to 156 times slower.
    >
    >
    >


    But you have to ask why is that speed being used SO MUCH - the answer is
    probably that your computer is trying to read through files that are on
    the VPN system - this is very inefficient. What you want is a
    client-side (your computer) that gets results from a server (at the
    other end of the VPN) which is where the data files are scanned.

    It is Not just about the speed.


  4. #4
    stephen
    Guest

    Re: Database applications over VPN

    "r042wal" <rob@wiztalknospam.ca> wrote in message
    news:mddHj.4532$9X3.4477@edtnps82...
    > Why do database applications not work well over VPN?


    There is no specific reason - database apps can be written to work well over
    a WAN.

    I have tried a few
    > proprietary applications that are SQL driven and they are painfully slow,
    > but even something as simple as ACT or QuickBooks will not work well over
    > VPN.


    These apps use SQL queries - but there is an "old saying" - any programmer
    can defeat good tools and networks.....

    what seems to cause the issue is writing the app so that there are large
    numbers of separate transactions that happen serially - add latency within a
    transaction and everything slows down in proportion.

    now consider that a LAN may have turnaround times well below 1 mSec, and a
    typical broadband link will have 10s or 100s of mSec, and slower equipment
    to traverse such as home routers, multiple firewalls, VPN gear, and you see
    where the difference comes from.

    i have seen lots of apps that could have been written so that 1 query is
    sent, and then the results are streamed back (which means 1 turnaround for a
    set of results) - but they do a "give the next record" type query (1 per
    record).

    What is the reason behind this?
    >


    bad programming, and more seriously, poor or inappropriate testing.

    the biggest single reason i come across is that the developers always seem
    to have the latest machines, modern fast servers with few other users and
    and access on a local LAN.

    and then you roll it out and suddenly realise it doesnt like your old
    machines, slow WAN links, remote workers......

    Make them work on a remote broadband link and your apps will suddenly get
    better :)

    --
    Regards

    stephen_hope@xyzworld.com - replace xyz with ntl



Similar Threads

  1. Replies: 9
    Last Post: 07-23-07, 11:20 AM
  2. Adding VPN Router to Existing Network
    By sheider in forum Wireless Networks & Routers
    Replies: 5
    Last Post: 01-17-07, 08:28 AM
  3. Connecting 2 VPN networks in one site.
    By laberlaber in forum Wireless Networks & Routers
    Replies: 1
    Last Post: 11-20-06, 08:37 AM

Bookmarks

Posting Permissions

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