PDA

View Full Version : Database applications over VPN



r042wal
03-28-08, 04:14 PM
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?

Mike Drechsler - SPAM PROTECTED EMAIL
03-29-08, 01:43 PM
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)

Rick Merrill
03-29-08, 04:56 PM
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.

stephen
03-30-08, 10:52 AM
"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