Sure. When you connect at your client you probably have a 100 megabit per second link to the server holding the database. When you run R:BASE on your laptop and execute a SELECT you have a pretty reasonable pipeline through which the data is moved.
At home, the speed of the VPN is certainly no faster than your own connection to the internet. If you have broadband, that is probably in the range of 2-6 megabits per second. This is a much smaller pipeline through which the data must move, as in 1/50th to 3/50th the speed. So if you run R:BASE on your laptop, it will be very slow since the data has to move through a straw instead of a 6” pipe. Now, if you RDP to the server and run R:BASE on the server desktop, the pipeline is as big as the disk I/O subsystem in the server, with the obvious overhead of other users, etc. That will be far faster than even the 100 mbps connection at the client. Emmitt Dove Converting Systems Architect Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Monday, November 22, 2010 16:41 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Off topic Emmitt: I know nothing technical about VPNs, but don't understand the significance of where the code is. For an example, if I'm at Wrigley with my laptop connected to the network it can take 2 seconds to execute a select command with a where clause. Take that same laptop home and connect to the network via a VPN (so I'm not remoting into another workstation) and that same select could take 15 minutes. Exactly what makes the VPN so slow then? Is there an easy (non-tech) way to explain that for me? Karen Jim, The question to answer is, “Where is the code that is accessing the database actually executing?” Emmitt Dove
