Re: stored procs

From: <andreas.prusch_at_sintec.de>
Date: Thu, 11 Jun 1998 13:39:01 GMT
Message-ID: <6lomlm$dns$1@nnrp1.dejanews.com>

We had a bug in 7.3.2 which permanently increases memory. The bug based on function callings to stored procs like while f(x) loop and exit when f(x). We must replace this calls with y := f(x); while y loop and so on. Hope this will help.

Andreas Prusch

In article <357EC35B.A6917928_at_maik.rssi.ru>, vlmol_at_maik.rssi.ru wrote:
>
> Hello.
> Probably my question is dull.
> I use client, which periodically (twice per min) invokes at the server
> side stored procedure scanning several tables
> and making report.
> Why RAM used by the client process slow but constantly increases
> (1M/hour)? Is it bug associated with
> stored proc - I'm using version 7.3.
> Why server logging this process - I do not using any updates in this
> procs - only selects?
> Thank you in advance.
> --
> William
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Jun 11 1998 - 08:39:01 CDT