Database applications over VPN

Database applications over VPN

NewsGroups | Search | Tools
 comp.dcom.vpn  Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Database applications over VPN r042wal 03-28-2008
Posted by r042wal on March 28, 2008, 5:14 pm
If you were  Registered and logged in, you could reply and use other advanced thread options
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?


Posted by Mike Drechsler - SPAM PROTECTE on March 29, 2008, 2: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)

Posted by Rick Merrill on March 29, 2008, 5: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.


Posted by stephen on March 30, 2008, 11:52 am
> 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 ThreadsPosted
Voice mail informations, applications, systems... July 31, 2006, 1:40 pm

other useful resources:
The Federal Communications Commission (FCC)
Telecommunications Industry Association
Electronic and Software Security Products and Services
International Telecommunication Union

Custom CGI Perl and PHP programming by 1-Script.com

Contact Us | Privacy Policy
The site map in XML format XML site map