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
