James, I was going to try your suggestion but this morning the view works as expected. Lightning fast. Go figure.
Maybe you just need a computer restart occasionally when you get some weird results. Trying that now. Got a message that windows had a delayed write failure writing the RB1 file. The latter part of my post asked the question about the help files. I just get the windows explorer message the the file is unavailable. Don't remember changing any settings but the helps are not there. Jan ----- Original Message ----- From: "James Bentley" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Thursday, July 14, 2005 9:01 AM Subject: [RBG7-L] - Re: View Optimizing > 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 > > >
