Re: How to increase the speed of a Function
Don't write a function to do this, use GROUP_CONCAT():
select group_concat(
concat(
designation
, ' '
, 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
see:
http://dev.mysql.com/doc/refman/5.0/en/GROUP-BY-Functions.html
Edited 1 time(s). Last edit at 11/07/2005 05:00PM by Roland Bouman.
Subject
Views
Written By
Posted
3560
November 07, 2005 03:31PM
Re: How to increase the speed of a Function
3806
November 07, 2005 04:59PM
2178
November 07, 2005 07:57PM
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.