I'm having trouble with the app_history table, and I'm not sure why this is happening. The problem occurs in 2 different scenarios:
The first one is when I try to edit a dynaform. Once I click the "edit" link, the application starts to read the app_history like there's no tomorrow, and I have to wait for 2 to 3 minutes before the dynaform edit page opens. You can see this in the attached image "History_table.png".
The second scenario is when I try to export the process. This case is worse, because it takes so long for the application to generate the process "package", that it times-out, making it impossible for me to export most of my processes.
I don't even know why this table is being read. It makes no sense to me that the history table should be queried when opening a dynaform of exporting a process definition, but (hopefully) there may be a reason.
Has anyone ever had this kind of problem? Is there a solution?