El nexo entre tecnología y negocios
 
[ AHF00122 ] Improvement in the performance of task's list
Summary
The performance of the task's list and the functionality "Task's release" are improved, through the usage of the new index.

It is applied to
  • 2.2.154.x
  • 2.2.162.x
  • 2.2.163.x


Symptoms
  • Very long times to see the information in the list of "Acquired Tasks".
  • Very long times to see the information in the list of "Task's Release".


Solution
The solution consists of the creation of a new index.

To all data bases
CREATE INDEX IX_PRO_ELE_INST_TSK_LIST on PRO_ELE_INSTANCE (ENV_ID,PRO_ELE_INST_STATUS,PRO_ELE_INST_USER_ACQUIRED)


Related from
[ AFC00108 ] Changes in "Tasks list"
[ AHT00162 ] Performance improvement in PostgreSQL online queries
Suggested items
[ AHF00065 ] Improvement in the performance of the functionality "Task's release"
[ ATI01616 ] Datasheet "Queries - Run Tasks' list UQ"
[ AHF00021 ] Error in the tasks' list when working with attributes. It is not showing all the tasks
[ AFC00314 ] Parameter to hide the window "Complete task"
[ AFC00197 ] Tasks' graphics in ApiaDesk
[ AHF00112 ] Error when performing actions of tasks in a query
[ AFC00196 ] Group tasks of Apia Desk's Tasks' list using the concept of folders
[ ANF00233 ] Automatic task activation
[ AHT00175 ] Application for mobile devices that allows seeing and working user tasks
[ AFC01775 ] Work a task with double click