Hi,
Do not use look-up variables! Use a store procedure instead. That will
increase the speed.
Creating a view with more than five tables will slow down the whole process,
but some times including more restrictions into WHERE clause should be
useful.
Konstantin
>From: "Alastair Burr" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: Speed and/or efficiency of views in reports
>Date: Thu, 21 Jun 2001 15:06:16 +0100
>
>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.
>
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
