Exactly, the ‘&’ is not mandatory. Both queries return the same result.
Rudy Mortier Two Way Communications bvba > On 29 Jul 2018, at 22:23, Douglas von Roeder via 4D_Tech > <[email protected]> wrote: > > Bob: > > I think that's a shortcut from many years ago so it's an implicit "&". > > -- > Douglas von Roeder > 949-336-2902 > > > On Sun, Jul 29, 2018 at 1:12 PM Robert McKeever via 4D_Tech < > [email protected]> wrote: > >> Either they have changed the way QUERY works, or you are missing …&;… >> after the first semi-colon on lines 2, 3, and 4 of the QUERY. So, it looks >> like you are really simply searching for just the last line. Probably would >> be quicker. >> >>> On Jul 29, 2018, at 4:47 AM, Two Way Communications via 4D_Tech < >> [email protected]> wrote: >>> >>> I am a bit confused… isn’t ORDA supposed to be faster than traditional >> queries? >>> >>> I did a test with a table containing 120,000 records. The query is on 4 >> indexed fields and returns 54,000 records. >>> >>> Doing the query with ORDA takes 175 milliseconds. >>> Doing the query with QUERY takes 4 milliseconds. >>> >>> Why?? >>> >>> ORDA: >>> $oQRYoption:=New object("queryPlan";False;"queryPath";False) >> >>> $oTLD:=ds.T_Loggers_data.query("TLR.FK_REAP =:1 AND TLD_timestamp >=:2 >> AND TLD_timestamp <=:3 AND Excluded >> =:4";[REAP_sections]FK_REAP;$TSsectionStart;$TSsectionEnd;False;$oQRYoption) >> >>> >>> >>> Traditional: >>> >> QUERY([T_Loggers_data];[T_loggers_readings]FK_REAP=[REAP_sections]FK_REAP;*) >> >>> QUERY([T_Loggers_data];[T_Loggers_data]TLD_timestamp>=$TSsectionStart;*) >>> QUERY([T_Loggers_data];[T_Loggers_data]TLD_timestamp<=$TSsectionEnd;*) >>> QUERY([T_Loggers_data];[T_loggers_readings]Excluded=False) >>> >>> >>> Rudy Mortier >>> Two Way Communications bvba >>> >>> ********************************************************************** >>> 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] >>> ********************************************************************** >> >> _________________________________________ >> Bob McKeever http://www.mswl.com < >> http://www.mswl.com/> >> McKeever's Software Wizardry >> Port Coquitlam, B.C. >> [email protected] >> >> >> >> >> ********************************************************************** >> 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] >> ********************************************************************** > ********************************************************************** > 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] > ********************************************************************** ********************************************************************** 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] **********************************************************************
