When using record slection formulas
1 Use stored procedures wherever possible. There is an updated vcl on their
website which allows you to change sp paramaeters.
2 use crystal parameters in your section formula whereever possible. These
can be set via the vcl as well. parameters are used in the the sql select
statement (filtered at server = good) whereas formulas are filtered locally
(= v. bad).
Either of these to techniques will make a huge difference to report time.
(on 6.5 at least)
Sean
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Rohit Gupta
> Sent: Wednesday, 17 March 1999 02:15
> To: Multiple recipients of list delphi
> Subject: Re: [DUG]: Crystal Reports (was: Report Builder Pro)
>
>
> Hi Steve,
>
> Its worth mentioning to anyone using Crystal, in case they have not
> realised. The dratted thing reads every record matching the filter
> of the master table primary index... and all the linked records. It
> then makes a new master table with everything in it.
>
> Thats my understanding anyway. :-)
>
> On 13 Mar 99 at 17:34, Steve Peacocke wrote:
>
> > Definately. I thought it was a real show stopper in a couple of
> cases. When
> > I first reported it to this group, I suggested that an
> unsuspecting report
> > can pull the whole server down.
> >
>
> Rohit
>
> ======================================================================
> CFL - Computer Fanatics Ltd. 21 Barry's Point Road, AKL, New Zealand
> PH (649) 489-2280
> FX (649) 489-2290
> email [EMAIL PROTECTED] or [EMAIL PROTECTED]
> ======================================================================
>
> ------------------------------------------------------------------
> ---------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
