activiti database index

[christoph_retti]

Hello, is there some guide on which database index should be placed per default on a fresh activiti (5.10) installation.

I had some database locks and checked the (SQL Server 2008) database (found some hints here in the forum) and there is no index at all on the database

Maybe you could post a list of index you would recommend to have a starting place for me?

  regards, chris

[jbarrez]

No indexes?

I checked the activiti.mssql.create.engine.sql file and found these for the runtime alone:


create index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION(BUSINESS_KEY_);
create index ACT_IDX_TASK_CREATE on ACT_RU_TASK(CREATE_TIME_);
create index ACT_IDX_IDENT_LNK_USER on ACT_RU_IDENTITYLINK(USER_ID_);
create index ACT_IDX_IDENT_LNK_GROUP on ACT_RU_IDENTITYLINK(GROUP_ID_);
create index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR(CONFIGURATION_);
create index ACT_IDX_VARIABLE_TASK_ID on ACT_RU_VARIABLE(TASK_ID_);
create unique index ACT_UNIQ_RU_BUS_KEY on ACT_RU_EXECUTION (PROC_DEF_ID_, BUSINESS_KEY_) where BUSINESS_KEY_ is not null;
create index ACT_IDX_ATHRZ_PROCEDEF on ACT_RU_IDENTITYLINK(PROC_DEF_ID_);

If you don't have any indexes, I'm afraid something has gone wrong there …

[christoph_retti]

Hi, I am really sorry, there was a mistake by my side!

I transferred the database schema from a remote activiti database for testing to my local instance and it seems that MS SQL Server 2008 Management Studio
does not create the datanbase index in this case - so I was left without any primary key, index or foreign references

sorry for that!!!

  chris