Mike, Here is explanation from Rbase Help "Syntax: SET MANOPT ON/OFF Default: OFF
MANOPT disables the automatic table-order optimization that R:BASE performs when running queries. This gives maximum control over the order in which columns and tables are assembled in response to a query. With MANOPT on, R:BASE uses the order of the tables in the FROM clause and the order of the columns in the column list of the SELECT clause to construct the query." Since you are using a view (I assume from naem ProdView) something is confusing/affecting the RBase Optimizer when you use default MANOPT OFF. To the best of my knowledge unless you are using an large number of tables in the view running with the default is best course of action. Normally the optimizer is very good at selecting best method of retrieving data. However it is not fool proof hence the MANOPT ON switch. Sever things. If indexes are in view have you packed the indexes lately. Have you attempted to use MICRORIM_EXPLAIN system variable. "System variable that displays optimization information. 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 listed in Help file." If you post the code for the view perhaps we can spot why some problem. Remember with VIEWS and the selection of a subset of data from the VIEW you can experience significant performance derogation from an ill constructed view. Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 --- On Thu, 8/14/08, Dan Goldberg <[EMAIL PROTECTED]> wrote: > From: Dan Goldberg <[EMAIL PROTECTED]> > Subject: [RBASE-L] - RE: Turbo V-8 vs. 7.5 performance > To: "RBASE-L Mailing List" <[email protected]> > Date: Thursday, August 14, 2008, 1:24 PM > Just curious, when the MANOPT is ON and you say you get the > similar > performance. Is the same as the few seconds you say in > paragraph two?? > > Dan Goldberg > > _____ > > From: [email protected] [mailto:[EMAIL PROTECTED] On > Behalf Of Ramsour Mike > Sent: Thursday, August 14, 2008 11:12 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Turbo V-8 vs. 7.5 performance > > > > Here's the situation: > > > > Query: Bro * from prodview where unit_no='1709' > and grade='1215' > > > > Results in a few seconds against 7.5 database with 490,305 > rows > > > > Results 10+ minutes and waiting from 8.0 database upgraded > from previously > mentioned 7.5 database (only with 171,000 fewer records) > > > > All things being equal, table structures, indexes and view > structures are > the same between both versions. > > > > Using a SELECT statement gives decent results in both > versions but the > BROWSE just dies in V-8. Interestingly if I set MANOPT ON > then I get > similar BROWSE performance between both versions. > > > > Why is there such a difference between the versions and > more importantly > what can I do about it? Is it better to run with MANOPT > ON? > > > > Thanks for any feedback. > > Mike Ramsour > AK Steel Coshocton Works > Quality Department > > Phone/VMS: 740-829-4340
