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] **********************************************************************
