Thank you all for an excellent reminder/tutorial on an "overlook-able"
design choice of consequence.
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 Mobile
------ Original Message ------
Sent: 6/3/2016 6:22:16 AM
Subject: Re: [RBASE-L] - speeding up searches in a view
From: "karentellef via RBASE-L" <[email protected]>
To: [email protected]
Cc:
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.
