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.
