Hello!
I have a view that will hold a lot of data. I wanted to
search it 2 ways for these where clauses:
repdate between .... and trantype <> 'fr'
repdate between .... and trantype = 'fr'
The first search is very fast. The second search I had to
reboot RBase after it was still chugging after 20 minutes.
For the heck of it I changed it to
repdate between .... and trantype = ('fr')
Now it's as fast as the first search! Rbase won't use indexes
when the where clause is "<> 'fr'", so I had to do the same for
the "= 'fr'". Putting it in parenthesis did the job!
Put this on your list of "gotta remember to try that the next
time I have a slow view"....
Karen
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
