Re: Slow Crystal Reports with Oracle
From: kristoff plasun <a_at_a.com>
Date: Fri, 17 Oct 2003 17:40:39 GMT
Message-ID: <rQVjb.34719$S_.20576_at_clgrps13>
Date: Fri, 17 Oct 2003 17:40:39 GMT
Message-ID: <rQVjb.34719$S_.20576_at_clgrps13>
> But creating a view is little different to creating a stored procedure.
> Either way, you have created something on the server - ten lashes!
he he good point! :-)
> Which would they prefer?
>
> a) CR brings the server to its knees every time someone runs a report,
> so basic reports can only be run out of hours or against a separate,
> not-quite-up-to-date data source; or
>
> b) you build some views and stored procs in a separate schema to enable
> reporting to run efficiently?
I think I'll go the view way.
Thanks for your help!
kristoff plasun Received on Fri Oct 17 2003 - 19:40:39 CEST