AnsweredAssumed Answered

Performance issue on task complete

Question asked by bcelikcan on Jun 12, 2012
Latest reply on Jun 15, 2012 by bcelikcan

In last week we have performance issiues in activiti task complete queries.

Finally We have found a clue on database side. We are using Oracle 10g and our searchs must be case insensitive.
So we put two script on database logon;

            execute immediate 'alter session set nls_sort = ''TURKISH_AI''';
            execute immediate 'alter session set nls_comp = ''linguistic''';

After this configuration activiti query execution times incerased almost 4 times.
Activiti database tables have nvarchar2 private keys. Problem might be here.

My previous post is gone to developer forum by the way. Sorry for that.

Any suggestion will be appreciated.