4D Server in the cloud

2016-09-28 Thread Ben Ferber
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 run

Re: 4D Server in the cloud

2016-09-29 Thread Andrea Angeli
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 t

Re: 4D Server in the cloud

2016-09-29 Thread Arnaud de Montard
> Le 28 sept. 2016 à 23:55, Ben Ferber a écrit : > > Hi All, > > One of my clients is considering moving all of their servers to a cloud [...] > Any and all feedback appreciated! I had the chance this year to develop a while in such situation. It's important to develop and test with the WAN b

Re: 4D Server in the cloud

2016-09-29 Thread Kirk Brooks
Ben, i have been running 4D server from my own server in a colo for the past 12 years (since v2004). Clients connect directly via WAN, we don't use terminal server or anything like that. The colo provides gigabit connection to the network. On Wed, Sep 28, 2016 at 2:55 PM, Ben Ferber wrote: > > -

Re: 4D Server in the cloud

2016-09-29 Thread David Adams
Just one quick point about running a VM on shared hardware. If there are multiple VMs, you can't be sure what's going to happen to your access to I/O. If the other VMs are idle, no problem. If they're using RAM, no problem...but if they're reading to or writing from disk...that can be a problem. So

Re: 4D Server in the cloud

2016-09-30 Thread Arnaud de Montard
> Le 29 sept. 2016 à 21:04, Kirk Brooks a écrit : > > [...] you will need to examine how you do such queries and probably > modify code. Execute on server is vital. [...] Some examples, to illustrate… Never use While(not(end of selection())) I had to display or print many pictures (a kind of

Re: 4D Server in the cloud

2016-09-30 Thread Alan Chan
Are you sure this command won't be sent to server? Nonetheless, the result would be returned in one traffic. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: > SET FIELD RELATION(foreignKeyParent1;automatic;do not modify) > SET FIELD RELATION(foreignKeyParent2;automatic;do not modify)

Re: 4D Server in the cloud

2016-09-30 Thread Arnaud de Montard
> Le 30 sept. 2016 à 11:00, Alan Chan a écrit : > > Are you sure this command won't be sent to server? Hi Alan, no, just faith ;-) Olivier Deschanels told me it's a "setting" and 4D is optimized to wait for the next data query to send it at the same time. Most probably many commands (SET QU

Re: 4D Server in the cloud

2016-09-30 Thread DEddy
Kirk - > > i have been running 4D server from my own server in a colo > Is colo considered "Cloudy" enough? Or not? - David - Running 4D v15.2, OS X v10.11.5, Foundation v5.6.1 -- View this message in context: http://4d.1045681.n5.nabble.com/4D-Server-in-the-clou

Re: 4D Server in the cloud

2016-09-30 Thread Alan Chan
Hi Arnaud, I explicitly asked about these questions like Query (*), I was told each query would be sent individually but won't executed until the last was sent. Query([table];[field1]=1;*) Query([table];&;[field2]=2;*) Query([table;&;[field3]=3) 3 traffic would be sent. Yes, I admitted that I w

Re: 4D Server in the cloud

2016-09-30 Thread Kirk Brooks
David, On Fri, Sep 30, 2016 at 12:18 PM, DEddy wrote: > Is colo considered "Cloudy" enough? Or not? > ​I guess that depends on how sophisticated your audience is. We've got our own IP, our own domain and it's not in our basement. That's at least foggy. -- Kirk Brooks San Francisco, CA ==

RE: 4D Server in the cloud

2016-09-30 Thread Timothy Penner
> Is colo considered "Cloudy" enough? Or not? The "cloudiness" of the colo depends on which floor the server is located on; the higher up the more chance of being in the clouds ;-) Happy Friday! -Tim ** 4D Internet Users Grou

Re: 4D Server in the cloud

2016-10-02 Thread Arnaud de Montard
> Le 1 oct. 2016 à 00:25, Alan Chan a écrit : > > Hi Arnaud, > > I explicitly asked about these questions like Query (*), I was told each > query would be sent individually but won't executed until the last was sent. > [...] Hi Alan, then one of our "source" is wrong - one more reason to doc

Re: 4D Server in the cloud

2016-10-02 Thread Douglas von Roeder
On Sun, Oct 2, 2016 at 3:56 AM, Arnaud de Montard wrote: > then one of our "source" is wrong - one more reason to document that! > > I tried executing some queries in TRACE and look at the process tab on > server at the same time (v14R5): > I think it was during the Summit in San Antonio that s

Re: 4D Server in the cloud

2016-10-02 Thread Alan Chan
Hi Arnaud, Thanks for your test. Definitely i hope that mine is wrong. I'll do a clean sniffer by segmenting a single client/server once I finish a little project on hand to clear my doubt for these years. I hate being lazy:-( Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >then on

Re: 4D Server in the cloud

2016-10-02 Thread Alan Chan
I heard that 4D has been doing a lot of traffic optimization in recent version. They might have eventually getting serious about this. Interestingly, Read Only/read write was also one of those command I asked. I also asked if Table/field/table name/field name would be sent to server to resolve

Re: 4D Server in the cloud

2016-10-02 Thread Douglas von Roeder
Alan: My recollection is from a Summit three years ago so I could be wrong on the specifics but the premise is solid - reduce traffic by "grouping" commands. On Sunday, October 2, 2016, Alan Chan wrote: > I heard that 4D has been doing a lot of traffic optimization in recent > version. They mig

Re: 4D Server in the cloud

2016-10-02 Thread Alan Chan
I should have written "recent versions" instead of "recent version":-) The questions I raised was many, many years ago (at least pre-v11). As all we know, 4D performance greatly improved over the network in recent versions including those cross table queries whick I dared not to touch before. I

Re: 4D Server in the cloud

2016-10-05 Thread Arnaud de Montard
> Le 2 oct. 2016 à 20:34, Alan Chan a écrit : > > [...] > I also asked if Table/field/table name/field name would be sent to server to > resolve or just from local resources downloaded during login on compiled > version. Hi Alan, I'm *sure* those are read from local resources, and most proba

Re: 4D Server in the cloud

2016-10-05 Thread Alan Chan
That's great. Many of information I got was decades ago. Laurant told me that those commands need to access the server since some users change table/field name in a live system. I asked if 4D access local structure resources if it's run in compiled. He replied that it could be done ... etc. I di