I am surprised that doing two things takes 20 times longer rather than twice as long.
> On Jun 3, 2016, at 9:22 AM, karentellef via RBASE-L > <[email protected]> wrote: > > Dan is right. If you have vDate predefined, then RBase just has to do one > thing: Is this row > 6/3/15? But in your first command it has to do two > things as it goes thru each row: what is the value of (.#date - 365), then > is this row > that value? > > Karen > > > > -----Original Message----- > From: Dan Goldberg <[email protected]> > To: rbase-l <[email protected]> > Sent: Thu, Jun 2, 2016 5:51 pm > Subject: RE: [RBASE-L] - speeding up searches in a view > > Because when you put the calculation in the command it has to evaluate it for > each row. > > Dan Goldberg > > From: [email protected] [mailto:[email protected]] On Behalf Of > Michael J. Sinclair > Sent: Thursday, June 2, 2016 3:48 PM > To: [email protected] > Subject: [RBASE-L] - speeding up searches in a view > > Hi all, > > I was doing a search of a two table view with about 1 million rows. > The column I am using has an index. > > This search was very slow..... > > BROWSE ALL FROM viewname WHERE columname > (.#date - 365) > > This search was almost instant > > SET VAR vdate = (.#date - 365) > BROWSE ALL FROM viewname WHERE columname > .vdate > > > Why is there such a big difference? > > Mike > > -- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
