Re: Help with Database Performance Estimation

In article <746484816snz_at_pro-data.demon.co.uk> Chrisj_at_pro-data.demon.co.uk writes:

>In article <1993Aug27.173206.18011_at_source.asset.com> mcconnel_at_source.asset.com
> writes:
>
>> I am trying to put together some sort of prediction as to the
>>amount of slowdown in performance I can expect as our database grows
>>(we expect it to triple very soon). I am particularly interested in
>>cpu time and elapsed time.
>>
>>I AM concerned that memory buffering will throw off my resulting times.
>>
>How about doing all queries through VIEWs which, as I understand
>Oracle's implementation, don't buffer pages in memory.
>--
>Chris Jack
>

        This is just not true, the view text is merged with the current sql command at parse time. The data is returned from the same data pages whether a view is involved or not. Received on Sun Aug 29 1993 - 11:42:47 CEST