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 <
4d_tech@lists.4d.com> 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 <
> 4d_tech@lists.4d.com> 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:4d_tech-unsubscr...@lists.4d.com
> > **********************************************************************
>
> _________________________________________
> Bob McKeever http://www.mswl.com <
> http://www.mswl.com/>
> McKeever's Software Wizardry
> Port Coquitlam, B.C.
> bobmckee...@mac.com
>
>
>
>
> **********************************************************************
> 4D Internet Users Group (4D iNUG)
> Archive: http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
> **********************************************************************
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**********************************************************************
