Doug, I've been running a db over WAN since v2004. I've found v15 to be more stable than any of the others but I'm also running it on the legacy setting. I've changed to the new one a couple of times and it always gets complaints from users about responsiveness or sluggishness. I don't have any v16 databases running with appreciable load yet but the one I do have in production is totally acceptable with the new network layer.
Miyako is right, as I'm sure you know, about the attention you have to pay to exactly where operations take place like searches, loops and such all running on the server and not clients. But I'm guessing that's not the sort of problems you're seeing. The latency issue is still a bugger. Since it's highly dependent on the routing it's not something you can control completely and it can bite you. We had an issue a few years ago when a couple of our locations were on Comcast and Comcast and L3 were having a fight resulting in Comcast avoiding L3 connections. This resulted in the route from those offices, about 8 miles from our colo, requiring hopping all the way from here to Europe, turning around in Sweden ( I think) and then coming back to California if you were connecting from a Comcast node. This took a noticeable amount of time and 4D was not amused. Lead me to install a couple of lines from a local carrier just for the data while they had their pissing match. Actually we just ditched Comcast 'cause they are a miserable company to deal with. On Tue, Apr 4, 2017 at 12:20 AM, Douglas Cryer via 4D_Tech < [email protected]> wrote: > I would like to hear from anyone using v16 in a WAN environment. > > Frankly every time I have tried out v16 or for that matter any v15 R > release I have been shocked at how poor the network connection stability > has been. > > It seems to stem from the new networking layer and certainly it seems to > be more stable when the legacy networking checkbox is checked but frankly > it scared me off being an early adopter. > > I now have a little time to look at this again but wanted to gather some > information from the community before I proceed with more testing. > > Are there any recommended settings and configurations I should look at? > Some background: > > All our servers are running on Windows Servers mixture of 2008 and 2012. > - 90% are dedicated hosted servers with a few in-house servers > - Multiple databases run on our hosted servers on separate ports > - WAN connection for each server is dedicated 100Mb > - Client connections vary from domestic grade ADSL, Virgin Cable and > Leased lines > - Clients are a mixture of platforms 90% Windows 7, 8 & 10 and 10% OSX > > We have occasionally had issues with certain clients broadband connections > but all in all v15 stability has been good. > > Issues I was seeing with v16 were: > - Client connection timeout errors > - Clients which had logged off, showing as connected to the server > > Am I missing some key documentation in this area or maybe some new > networking layer tech note? > > Regards, Dougie > ________________________________________________________ > > telekinetix Limited- J. Douglas Cryer > Phone : 01234 761759 Mobile : 07973 675 218 > 2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE > Email : [email protected] <mailto:[email protected]> Web : > http://www.telekinetix.com <http://www.telekinetix.com/> > ________________________________________________________ > > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** -- Kirk Brooks San Francisco, CA ======================= *The only thing necessary for the triumph of evil is for good men to do nothing.* *- Edmund Burke* ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
