Re: R: Public variables

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Wed, 07 Nov 2001 16:29:12 GMT
Message-ID: <3be960d8.66465640@news.alt.net>

On Wed, 7 Nov 2001 14:33:17 +0100, "Fabio GRANDE" <fabiog_at_fileita.it> wrote:

>Because values that I wanna store into public variables ARE stored in tables
>!!!!!
>I think that putting those values in variables I could improve the DB
>performances... Is it right ?
>I check those values many times during the execution of triggers and
>procedures using SELECT statements... But I'm looking for a way to improve
>the execution speed or my procedures...
>Thanx in advance
>Fabio GRANDE
>

I am just guessing, but if it were a very small table, wouldn't it help if you added STORAGE (BUFFER_POOL KEEP)?

Brian Received on Wed Nov 07 2001 - 10:29:12 CST