Re: Please Help DB Buffer Cache Size

brijeshmathew_at_gmail.com wrote:

> Some of my queries are becoming slow, as the data in database is
> increasing. I shall explain one of the functions that shows a real slow
> down is below.
>
> ---------------------
> CREATE or replace FUNCTION getnumberofshowsforPeriod(lmno IN NUMBER,
> fromDate In Date, toDate In Date)
> RETURN NUMBER is
> cursor c1 is select count( distinct s_no) lCount from s
> where mno = lmno and valuedate between fromDate and toDate group by
> valuedate , tid;
>
>
> lNoOfShows Number(5);
>
> BEGIN
> lNoOfShows := 0 ;
> for lcur in c1 loop
> lNoOfShows := lNoOfShows + lCur.lCount;
> end loop;
>
> RETURN(lNoOfShows);
> END;
This is a joke, right?
Would you care to explain to yourself, loudly, what this code does?

Please tell me this is an example of code, written -or better yet: generated- in an offshore software shop.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...