Pervasive
Sign in | Join | Help
in

v10 vpn performance

Last post 05-13-2008 5:36 AM by Gordon. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 05-12-2008 11:28 AM

    v10 vpn performance

    Hi all,

    I have used older versions of psql in the past (2000i, 8) and have had performance issues when connecting to a server engine through a VPN tunnel.

    I wish to write an application where some data is sent/retrieved to/from a central office. The office has a T1 and the clients have DSL (20-40 client locations). IS a direct VPN connection to a PSQL Server engine the way to go, should I communicate via XML, or other?  Volume will only be several records at a time on each seat.

    What would you folks suggest - so I can have as close to "real time" performance as possible. 

    Just sniffin' around...

    _Bill Roman

  • 05-13-2008 5:36 AM In reply to

    • Gordon
    • Top 75 Contributor
    • Joined on 08-30-2007
    • Delft, The Netherlands
    • Posts 62

    Re: v10 vpn performance

    The problem is distance, not bandwidth. Distance being relative of course since internet may route you through Paris and the next minute through Hongkong.

    With normal transactional access you'll make requests for small amounts of data, make some decisions based on the retrieved data and fetch more small amounts of data. Each request will cost you the full roundtrip time at least twice (Req. + ACK, Data + ACK). Example: using ping my LAN shows an average of 0.2ms, towards my local ISP 8ms and cross-Atlantic 24ms.

    With 40 times more network latency the challenge becomes to limit the number of communications. You should therefore make as little requests and at the same time retrieve as much data as possible. With a standard frame size of 1496 bytes which includes a header of upto 32 bytes you would benefit from reading or writing blocks close to but smaller than 1450 bytes. This is in fact what Pervasives client cache engine does: it fills the additional space in a network frame with data it anticipates you'll want next. Obviously if you do a lot of jumping around this mechanism will fail horribly so you should most definitly avoid doing this.


Page 1 of 1 (2 items)
© 2008 Pervasive Software Inc. All Rights Reserved.