topic Re: select query is too slow when i select byte(BLOB) data in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/select-query-is-too-slow-when-i-select-byte-blob-data/m-p/129285#M90841 <HTML><HEAD></HEAD><BODY><SPAN>How is this related to Activiti? This looks like a general database/ORM-question so don't think you'll get an answer here…</SPAN></BODY></HTML> Fri, 28 Jun 2013 07:33:23 GMT frederikherema1 2013-06-28T07:33:23Z select query is too slow when i select byte(BLOB) data https://connect.hyland.com/t5/alfresco-archive/select-query-is-too-slow-when-i-select-byte-blob-data/m-p/129284#M90840 Hi,&nbsp;&nbsp; I need to select the Avatar from database. Its take long itme.. It is BLOB type..This is the query,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select tab.userId,tab.avatar from UserTable; Also i tried thru. hibernate. Is there any&nbsp; sophisticated way select BLOB type ?Thanks. Fri, 28 Jun 2013 06:28:47 GMT https://connect.hyland.com/t5/alfresco-archive/select-query-is-too-slow-when-i-select-byte-blob-data/m-p/129284#M90840 stsivaraj 2013-06-28T06:28:47Z Re: select query is too slow when i select byte(BLOB) data https://connect.hyland.com/t5/alfresco-archive/select-query-is-too-slow-when-i-select-byte-blob-data/m-p/129285#M90841 <HTML><HEAD></HEAD><BODY><SPAN>How is this related to Activiti? This looks like a general database/ORM-question so don't think you'll get an answer here…</SPAN></BODY></HTML> Fri, 28 Jun 2013 07:33:23 GMT https://connect.hyland.com/t5/alfresco-archive/select-query-is-too-slow-when-i-select-byte-blob-data/m-p/129285#M90841 frederikherema1 2013-06-28T07:33:23Z