Bill Browse all from the view is fast with the same Where clause, So, I will look at these again.
Marc From: Bill Downall Sent: Tuesday, May 05, 2009 11:07 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: 7.5 vs V8 speed Marc, Is a simple "Select" with that where clause faster than a report generation? If so, check what Larry suggested (lookups), and also check "pass settings" to see if it is set to 2 passes, and if that can be changed to single pass. If the SELECT from the view is fast, and the report is slower, then just PROJECT TEMP tablename FROM VIEWNAME WHERE .... and print from a new version of the report -- copied from the original -- but which uses the temp tablename instead of the viewname. If the SELECT is slow, too, then you need to work on the view definition. Bill On Tue, May 5, 2009 at 12:01 PM, MDRD <[email protected]> wrote: Larry They are Indexed. Marc From: Lawrence Lustig Sent: Tuesday, May 05, 2009 10:43 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: 7.5 vs V8 speed << This view is complex at least for me but I am not sure that is the major snag, Doing Browse all from the view using the same Where clause is 1/4 the time to Print the report. >> Check all look-ups in the report and see if one of them is missing an index. -- Larry
