I'd have thought Records in Table would be quicker ... I'm sure 4D already "knows" how many records there are in each table, so it can just answer that question immediately rather than having to query and count the result ...
Pat On 19 October 2017 at 17:28, Dennis, Neil via 4D_Tech <[email protected]> wrote: > > Does anyone know the relative performance impact on a server of calling > a QUERY wrapped inside > > a SET QUERY DESTINATION (Into Variable...), compared to calling Records > In Table? > > In theory, related to each other the into variable would execute a bit > faster in that it isn't building and passing selections between client and > server. But I would bet the actual difference is pretty minimal. > > I would be curious if someone wants to set it up and test the actual time > :) > > Neil > > > > > > > -- > > > Privacy Disclaimer: This message contains confidential information and is > intended only for the named addressee. If you are not the named addressee > you should not disseminate, distribute or copy this email. Please delete > this email from your system and notify the sender immediately by replying > to this email. If you are not the intended recipient you are notified that > disclosing, copying, distributing or taking any action in reliance on the > contents of this information is strictly prohibited. > > The Alternative Investments division of UMB Fund Services provides a full > range of services to hedge funds, funds of funds and private equity funds. > Any tax advice in this communication is not intended to be used, and cannot > be used, by a client or any other person or entity for the purpose of (a) > avoiding penalties that may be imposed on any taxpayer or (b) promoting, > marketing, or recommending to another party any matter addressed herein. > ********************************************************************** > 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] > ********************************************************************** > -- ************************************************* CatBase - Top Dog in Data Publishing tel: +44 (0) 207 118 7889 w: http://www.catbase.com skype: pat.bensky ************************************************* ********************************************************************** 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] **********************************************************************
