Jan,
Create an .rmd file with the following commands:
SET DEBUG ON
SET VAR MICRORIM_EXPLAIN = 47
RETURN
At the R>
1. run the above command file
2. run each of the commands listed below
3. RBEDIT EXPLAIN.DAT
This will show you the strategy RBase choose to
process your commands. It might help you to
understand and possibly better optimize you views.
I Have also pasted in the explanation from
www.rsyntax.com regarding the MICRORIM_EXPLAIN
variable.
*(MICRORIM_EXPLAIN
This variable shows the decision the optimizer made
when executing a
particular command. The optimizer results are placed
in the file
EXPLAIN.DAT. The DEBUG command must be on to use
microrim_ explain.
The available options for microrim_ explain are
1 - output the table order.
2 - force optimization of joins over five tables.
This option is
ignored if microrim_fullopt is set.
4 - output the command file name and next byte
offset.
8 - output the current date and time.
32 - display the sort technique used.
To use multiple options, add the option numbers
together and set the
variable to the result. For example:
SET VAR microrim_explain = (1 + 4 + 8)
SET VAR microrim_explain = 13
)
--- Jan Johansen <[EMAIL PROTECTED]> wrote:
> Question,
>
> I have always used views to kind of speed up
> everything but sometimes that
> seems to provide the desired result.
>
> I have a view based on 3 tables. All linking columns
> are indexed. Record set
> of about 150,000.
>
> EDIT ALL FROM View WHERE Column1 = Query1
> --This gives results in < 1 Second
>
> EDIT ALL FROM View WHERE Column2 = Query2
> --This also gives results in < 1 Second
>
> EDIT ALL FROM View WHERE Column1 = Query1 AND
> Column2 = Query2
> --This gives results in about 10 Seconds
>
> Somehow I figured that the final query would be just
> as quick as the first
> two but maybe I'm doing it wrong.
>
> Also, somehow after the last update (707) my help
> files have disappeared in
> both 7.5 and 7.1
>
> Jan
>
>
Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
tel: 1-504-737-3293
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
