MySQL Forums
Forum List  »  Stored Procedures

Re: How to increase the speed of a Function
Posted by: Roland Bouman
Date: November 07, 2005 04:59PM

Don't write a function to do this, use GROUP_CONCAT():

select group_concat(
, ' '
, level
, strDel
separator ''
into returnStr
from cp_tsklevDes
inner join cp_designation
on fkey_deskey = deskey
where fkey_taskey = tskId

This would do away with the cursor and loop all together


Edited 1 time(s). Last edit at 11/07/2005 05:00PM by Roland Bouman.

Options: ReplyQuote

Written By
Re: How to increase the speed of a Function
November 07, 2005 04:59PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.