Date selection slow (AREV Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 07 MAY 2006 10:41:15PM mjmoran wrote:

AREV Specific

I have an rlist report which uses a date range criteria.

eg WITH DATE BETWEEN "1/1/06" AND "1/1/06"

The user can enter any date range, or a single day as above. The date field is btree indexed.

For some reason, the with+between is very slow. It almost looks as though indexing is not used at all. If I use "WITH DATE = I see the "using indexes" popup and the results are instantaneuous. But if I use "WITH DATE BETWEEN" (or ]= ⇐), even if the same date is used in the between-and, it seems to take so much longer (and I dont seem to see the "using indexes" popup).

Any ideas ?

Thanks,

Michael

At 08 MAY 2006 11:22AM Victor Engel wrote:

What else is in the select or list statement? What version of Arev are you using?

At 08 MAY 2006 02:13PM Ralph Johler wrote:

We too sometimes see this same problem. Instead of this:

WITH DATE BETWEEN "1/1/06" AND "1/1/06"

try this

WITH CASEINSENS DATE BETWEEN "1/1/06" AND "1/1/06"

Apparently the "Advanced" in Arev refers to the ability to have Case Sensitive dates?

At 09 MAY 2006 06:29PM mjmoran wrote:

Hi Victor,

Arev 2.12, and that is the only thing in the record selection criteria.

At 09 MAY 2006 06:30PM mjmoran wrote:

Thanks Ralph,

lol @ the case insensitive dates

I'll give it a try.

View this thread on the forum...