Alastair,
I have used both methods at my site and either
one works fine here. I have reports that have 15-20
lookups and reports that run off of views. I've never
noticed any difference in either method. You just might
want to pay a little attention to how the report is being
sorted and you index structure on your tables.
On Thu, 21 Jun 2001 15:06:16 +0100 Alastair Burr
<[EMAIL PROTECTED]> wrote:
> Does anyone have any opinions on or experience of the speed and/or the
> efficiency of views and look-ups when running reports?
>
> For example:
>
> Is it better to create a view that contains only the linked base data (eg: ID
> and code numbers) and then do look-ups (eg: names and other text) when running
> the report,
>
> or
>
> is a more complicated view with all the relevant columns included better so that
> no look-ups need be done when the report is run?
>
> Is there any point where choice might be different - high number of tables in
> the view against low number of look-ups or vice versa, perhaps?
>
> (The physical printer is irrelevant as I am saving the results to a file.)
>
> Regards, Alastair.
>
>
----------------------
Bob Powell
The Hotchkiss School
Lakeville, Connecticut
Systems Administrator
[EMAIL PROTECTED]
