select query is too slow when i select byte(BLOB) data

[stsivaraj]

Hi,
   I need to select the Avatar from database. Its take long itme.. It is BLOB type..

This is the query,
                            select tab.userId,tab.avatar from UserTable;

Also i tried thru. hibernate. Is there any  sophisticated way select BLOB type ?

Thanks.

[frederikherema1]

How is this related to Activiti? This looks like a general database/ORM-question so don't think you'll get an answer here…