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]<mailto:[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.
