It sounds like BROWSE is not optimizing queries correctly. The tipoff that this is happening is that MANOPT ON solves the problem. This basically skips the optimizer and does the query in the order you specify.
Dennis McGrath ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Ramsour Mike Sent: Thursday, August 14, 2008 1:26 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Turbo V-8 vs. 7.5 performance Correct. Mike Ramsour AK Steel Coshocton Works Quality Department Phone/VMS: 740-829-4340 ________________________________ From: Dan Goldberg [mailto:[EMAIL PROTECTED] Sent: Thursday, August 14, 2008 2:24 PM To: [email protected] Subject: [RBASE-L] - RE: Turbo V-8 vs. 7.5 performance 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
