Hi Ben, I had some experience using client on remote server and it is not easy give a good answer because depend on the number of records, the query and records size.
My experience with a new costumer that moved his server in a remote provider was dramatic! A developer put an image field in a table so if you make a query and the selection of records doesn’t contain image the client work fine with 2mb/sec, but if you have for example the first record of a selection with an image of 1.5 MB you need a connection at list of 10mb/sec. The database structure and query are the most important aspect to consider. Table that use any file or image inside the records should be a problem and query with field that update the selection every new char could be another problem. I work every day with remote 4D database with out image inside the records and with 10mb/sec 4D work fine with 2mb/sec is acceptable less could be very slow to give the selection back and also write code. Andrea ------------------------------------------------------------------- Alfanet srl [email protected] viale Europa, 62 http://www.alfanet.it/ 00144 Rome tel. +39 06 5924665 fax +39 06 5923352 > Il giorno 28 set 2016, alle ore 23:55, Ben Ferber > <[email protected]> ha scritto: > > Hi All, > > One of my clients is considering moving all of their servers to a cloud > computing platform - most likely Azure, but possibly AWS. This would include > a mission-critical 4D application, which is currently running on 4D Server > 13.6 on in-house servers in two locations. (All servers are running Windows > Server 2012; most clients are Macs.) The first concerns that come to mind for > me are performance and dropped connections between 4D and 4D Server. > Obviously, the speed and reliability of their internet connection(s) at each > location are critical variables. But I'm sure there are other issues I should > be thinking about as well... > > I would be interested in hearing from others who run 4D Server across the > internet from the clients. That includes hosting, colocation, and basic VPN > connections, but especially cloud computing platforms. > > And if you have considered or tried going down this road and then decided to > stick with on-premises servers, I'd be interested in what drove that decision. > > If you have successfully implemented a cloud-based solution, some questions: > - What internet connection speed (up/down) is adequate for performance to be > comparable to an in-house server? I know that depends on a ton of variables - > what works and doesn't work in your situation? > - Are dropped connections to 4D Server a problem for you? > - Is resource contention a problem? E.g. if someone is doing a sequential > query on a large table - or downloading a large file, etc. - does everyone > else's 4D performance suffer? > - Do you have redundant high speed internet connections? With or without > automatic failover? > - Other considerations that were major drivers for you, or major gotchas > (e.g. data security, backup, IT support costs, etc.)? > - Would you recommend a particular cloud platform? Why? > > Any and all feedback appreciated! > > Thanks in advance, > Ben > > ********************************************************************** > 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] > ********************************************************************** ********************************************************************** 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] **********************************************************************
