Hi guys , we have created a simple asp.net/sqlserver 2000 based Business Process Management tool in which we have a feature that user can create simple one column form and attached to the process and define rules and path.
We save the dynamically created forms controls values in EAV design tables but as the transactions is increasing we are have the performance issue on reporting on that custom forms values , my question is whats the alternative to this problem in which main requirement of the BPM solution is that user will create forms dynamically ,and what do u guys think the implementation of other big vendors of BPM like Skelta/ultimus/K2.net are managing this requirement. Do u thing xml can save me ?? if yes then how or How u guys will design the model of BPM applications