Re: Retrieving data using views & stored procedures. (doing it right?)

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Thu, 12 Apr 2001 16:44:23 +0100
Message-ID: <987090276.23355.0.nnrp-02.c30bdde2@news.demon.co.uk>

In addition to the other posts, I'd like to add that perhaps you may be thinking along the lines that code in stored procedures etc will get you a higher library cache hit ratio (thus better performance) than people issuing ad-hoc SQL queries. That's also a consideration...

"Charles McDonald" <cmcdon12_at_nospam.ford.com> wrote in message news:3AD454A4.4DAE0B86_at_nospam.ford.com...
> Hi all
>
> We are about to embark on a new development where the dB will be 8i. Now
> I have read a few references about accessing data in the dB by use of
> stored procedures, functions and views rather than direct table access.
>
> What is the *right* way? Soley stored procedures & views, a hybrid or
> direct access to the tables?
>
> Cheers
> Charles
Received on Thu Apr 12 2001 - 10:44:23 CDT