How to decrease SQL requests in Activiti ?

[Sakhr Talibi]

Hello everyone,

I worked with the plugin activiti for 2 years and i loved ! Thanks to Chee Kin Lim !

After configuring sql log with log4jdbc in my app, I see a lot of requests to database, and my app stops after many concurrent users !

I see after calling start(params) or completeTask(params) in my controller, it's about 20 SQL requests to database, there is no process variable (only two insert into ACT_RU_VARIABLE ...). sometimes it's going on 60 sql request if there is many variables in my params object. Is this normal ?

Also when I call start(params) in first time, I see a loop of sql requests (select * from ACT_RE_PROCDEF where DEPLOYMENT_ID_ = '4201' and KEY_ = xxxxx ) throughout all my process definitions.

How can I decrease these sql requests ?

Thank you so much.

[Chee Kin Lim]

Hi Sakhr Talibi,

Thanks for using and liking the plugin.

Your question is related to performance optimization, I re-post your question to Activiti Engine forum at the following URL:
http://forums.activiti.org/content/how-decrease-sql-requests-activiti

Let's see the developers there could help you.

Best regards,
Chee Kin

[Sakhr Talibi]

Ok, thank you for replay and for help.

Best regards