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 <[email protected]> > *Sent:* Tuesday, May 05, 2009 10:43 AM > *To:* RBASE-L Mailing List <[email protected]> > *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 > >
