Let the world know your discovery...
Chucho!
-----Original Message-----
From: rkusenet <rkusenet@gmail.com>
To: Jean Sagi <jeansagi@myrealbox.com>
Date: Thu, 23 Sep 2004 15:58:11 -0400
Subject: Re: Re: Re: Getting the number of rows returned by a select with group by.
Yes I believe there should be no problem if derived tables (TABLE(MULTISET)) is
used since technically we are not creating/dropping an object inside a SP.
I was forced to find other workarounds for the SP problem by using real tables
as global temp tables with SESSIONID column to link it to the session.
Much less
elegant than this.
However I am not sure how good the performance of derived tables. I will try to
do a bench mark.
On Thu, 23 Sep 2004 14:45:25 -0500, Jean Sagi <jeansagi@myrealbox.com> wrote:
>
> Besides...
>
> Let say you call stored procedure for every row in a query, _and_ inside the stored procedure you create and drop a temporary table...
>
> I had a lot of problems doing this, unitl someone give a solution to this by using exceptions...
>
> I think no problem exist by using _derived tables_
> .
>
> Chucho!
>
> -----Original Message-----
> From: "rkusenet" <rkusenet@gmail.com>
> .. The problem comes in stored procedures where creation/destruction of a temp table inside the SP forces the engine to recompile, which in turn puts a lock on sysprocplan...
>
>
> Jean Sagi
> jeansagi@myrealbox.com
> jeansagi@yahoo.com
>
Jean Sagi
jeansagi@myrealbox.com
jeansagi@yahoo.com
sending to informix-list