Re: Re: Re: Re: Getting the number of rows returned by a select with group by.

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