'Function' takes forever

We experience this as well (though since well before the last version) 

No, it appears the code group under Functionalities seems to work ok. It only takes seconds. I do not have any replacements in play here. 

Blommetje

Hi Mark, 

Tried it. The Functions took about 11 minutes. The query that was shown this time (and that I timed) is;

insert into #lines
                select iif(replace(ltrim(rtrim(replace(t.value, CHAR(13), ''))), char(9), '') = '', '', replace(t.value, CHAR(13), '')), t.ordinal, p.order_no
                from dbo.string_split_ordinal(@template_code, char(10)) t
                left join #template_parmtrs p
                  on t.value like '%\[' + p.parmtr_id + '\]%' escape '\'
                where not exists (select 1
                                    from #template_parmtrs p2
                                   where t.value like '%\[' + p2.parmtr_id + '\]%' escape '\'
                                     and (p2.occurrence_count > p.occurrence_count or (p2.occurrence_count = p.occurrence_count and p.parmtr_id > p2.parmtr_id)))

However, in a split second I thought I also saw; Not entirely sure.

select @code_file_generated_code = string_agg(po.prog_object_generated_code, '') within group (order by po.order_no, po.prog_object_id) 
    from prog_object po
    outer apply (select ex.prog_object_id
                 from get_excluded_prog_objects(po.model_id, po.branch_id) ex
                 where ex.prog_object_id = po.prog_object_id) excl
    where po.model_id       = @model_id
      and po.branch_id = @branch_id
      and po.code_file_id   = @code_file_id
      and po.prog_object_generated_code is not null
      and po.generated_code_stale = 0 -- Must be not stale
      and (@only_selected   = 0 
        or po.selected      = 1)
      and excl.prog_object_id is null

Does this make any sense? 

Thanks, 

Blommetje

Hi,

Opened a ticket in tcp for follow up. 

To be continued! 

Blommetje