topic Too many I/O exection with ACT_GE_BYTEARRAY table in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/too-many-i-o-exection-with-act-ge-bytearray-table/m-p/144023#M100745 <HTML><HEAD></HEAD><BODY><SPAN>Hi.</SPAN><BR /><BR /><SPAN>My team is using the Activiti for our project, and doing performance test now. (Version 5.9.3)</SPAN><BR /><BR /><SPAN>Load generator made total 1200 transactions in 20 minutes (only 2TPS), and&nbsp; system response time was getting worse..</SPAN><BR /><BR /><SPAN>I found that there were too many executions with ACT_GE_BYTEARRAY table.</SPAN><BR /><BR /><SPAN>And unfortunately there is a BLOB column(bytes_) in that table which is containing Process Definition (look like a bpmn file format)</SPAN><BR /><BR /><SPAN>There had been about 12000 executions for update, 14400 for delete, 52641 for select and 14400 for insert in 20 minutes.</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SQL&nbsp;&nbsp;&nbsp;EXECUTIONS</SPAN><BR /><SPAN>&nbsp;&nbsp; update ACT_GE_BYTEARRAY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; set&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; REV_ = :1 ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BYTES_ = :2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where ID_ = :3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and REV_ = :4 &nbsp;&nbsp;&nbsp;12000</SPAN><BR /><SPAN>&nbsp;&nbsp; delete from ACT_GE_BYTEARRAY where ID_ = :1 &nbsp;&nbsp;&nbsp;14400</SPAN><BR /><SPAN>&nbsp;&nbsp; select * from ACT_GE_BYTEARRAY where ID_ = :1 &nbsp;&nbsp;&nbsp;52641</SPAN><BR /><SPAN>&nbsp;&nbsp; insert into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_)&nbsp;&nbsp;&nbsp;&nbsp; values (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :1 ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :2 ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :3 ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp;&nbsp;&nbsp;14400</SPAN><BR /><BR /><SPAN>So my questions are</SPAN><BR /><BR /><SPAN>1. Is the ACT_GE_BYTEARRAY table used in runtime, not deploy time?</SPAN><BR /><BR /><SPAN>2. If so, what is the ACT_GE_BYTEARRAY table for? Insert big data(process definition), select(use) and delete for each step?</SPAN><BR /><BR /><SPAN>3. How can I reduce I/O count for the table?</SPAN><BR /><BR /><SPAN>Thank you <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://connect.hyland.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></SPAN></BODY></HTML> Mon, 29 Apr 2013 08:50:28 GMT gichulhong 2013-04-29T08:50:28Z Too many I/O exection with ACT_GE_BYTEARRAY table https://connect.hyland.com/t5/alfresco-archive/too-many-i-o-exection-with-act-ge-bytearray-table/m-p/144023#M100745 Hi.My team is using the Activiti for our project, and doing performance test now. (Version 5.9.3)Load generator made total 1200 transactions in 20 minutes (only 2TPS), and&nbsp; system response time was getting worse..I found that there were too many executions with ACT_GE_BYTEARRAY table.And unfortunate Mon, 29 Apr 2013 08:50:28 GMT https://connect.hyland.com/t5/alfresco-archive/too-many-i-o-exection-with-act-ge-bytearray-table/m-p/144023#M100745 gichulhong 2013-04-29T08:50:28Z Re: Too many I/O exection with ACT_GE_BYTEARRAY table https://connect.hyland.com/t5/alfresco-archive/too-many-i-o-exection-with-act-ge-bytearray-table/m-p/144024#M100746 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I don't think a version 5.9.3 exists of Activiti, so are you using Activiti 5.9? Any reason for using this older version?</SPAN><BR /><SPAN>How is the Activiti Engine configured? Which database are you using? How is this load generator communicating with the Activiti Engine?</SPAN><BR /><SPAN>The ACT_GE_BYTEARRAY is used to store complex content (non-primitives) such as deployment resources and non-primitive variables. </SPAN><BR /><BR /><SPAN>Before I can answer these questions you should first explain what you are testing. Are you doing a lot of deployments for example, then you all the deployment resources are stored in the ACT_GE_BYTEARRAY for example.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Mon, 29 Apr 2013 11:14:12 GMT https://connect.hyland.com/t5/alfresco-archive/too-many-i-o-exection-with-act-ge-bytearray-table/m-p/144024#M100746 trademak 2013-04-29T11:14:12Z