Re: [GENERAL] select sql slow inside function

2010-09-15 Thread Gary Fu
On 09/15/2010 09:46 AM, Gary Fu wrote: On 09/15/2010 02:28 AM, Sergey Konoplev wrote: Hi, On 15 September 2010 01:56, Gary Fu wrote I have a function proc_TaskComplete that inserts a record to table TaskHistory and then calls another function proc_ExportTaskComplete, that will retrieve (select

Re: [GENERAL] select sql slow inside function

2010-09-15 Thread Gary Fu
On 09/15/2010 02:28 AM, Sergey Konoplev wrote: Hi, On 15 September 2010 01:56, Gary Fu wrote I have a function proc_TaskComplete that inserts a record to table TaskHistory and then calls another function proc_ExportTaskComplete, that will retrieve (select) the record just inserted based on an

Re: [GENERAL] select sql slow inside function

2010-09-14 Thread Sergey Konoplev
Hi, On 15 September 2010 01:56, Gary Fu wrote: > I have a function proc_TaskComplete that inserts a record to table > TaskHistory and then calls another function proc_ExportTaskComplete, that > will retrieve (select) the record just inserted based on an index column > (TaskId) in that table TaskH

[GENERAL] select sql slow inside function

2010-09-14 Thread Gary Fu
Hi, I have a function proc_TaskComplete that inserts a record to table TaskHistory and then calls another function proc_ExportTaskComplete, that will retrieve (select) the record just inserted based on an index column (TaskId) in that table TaskHistory. I noticed that the select sql (inside