Jan,
Try creating an .rmd file with the following commands:
SET DEBUG ON
SET VAR MICRORIM_EXPLAIN = 47
RETURN
Then at the R> enter your edit commands. Then exit.
This will create a file EXPLAIN.DAT it will show how
rbase processed you command. This might help you
understand why it took longer to process the third
command you listed. I have also included an
explanation from rsyntax.com about 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
