I do the same as Jan in 7.6. Virtually all reports are running off temp
tables, and in my procedures are lots of temp views. I am somewhat
surprised at the stored procedure slowness compared to the r> prompt run.
Albert
On 14/09/2011 9:35 AM, jan johansen wrote:
Larry,
Where in the form does the code live?
Can you place the code in the ON BEFORE START eep?
As a workaround in 7.6, I used lots of TEMP vies and TABLES.
Still do in 9.1 which is why code seems much fast as well.
I know that there have been a number of engine fixes for 7.6 but also know
that it is out (going?) of service
Step up pricing for single user 9.1 is only $295
Jan
-----Original Message-----
From: Lawrence Lustig <[email protected]>
To: [email protected] (RBASE-L Mailing List)
Date: Wed, 14 Sep 2011 08:24:20 -0700 (PDT)
Subject: [RBASE-L] - Re: Code takes 20x longer inside form OR
stored procedure
<<
Maybe you should also give it a try using the RUN command.
>>
Yes, with the RUN command it takes 0.2 seconds. That's why I'm
surprised to find it takes longer from inside a form (even using
RUN outsideprogram.prg) or a stored procedure.
--
larry
