Thanks! on the first look it would appear to be simpler/faster to use Sql.
On Thu, 10 Jan 2019 21:15:48 +0100, Arnaud de Montard via 4D_Tech wrote: > >> Le 10 janv. 2019 à 20:21, cjmiller--- via 4D_Tech >> <[email protected]> a écrit : >> >> You could run it on server > > Running a method on server is great if there a lot of data to read > and/or write, because it avoids the transfer of these data through > network. Here the data is very small, time to ask server to run the > method and time to get that little data will be the same. Some times: > - using SQL ~ 250 ms 1st time, then ~60 ms (I don't know why 1st time > is longer, BTW) > - loop ~ 9 ms (and the server can do something better for other clients) > > -- > Arnaud de Montard > > > > > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** --------------- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************

