> My experience doing BLOB inserts with Postgres and DB2 and with
JBoss is that it's horribly slow. 



        This can be caused by the application design. Lets asume You have a
lage resultset and display some fieldes of each entiy in a table on the
client. Than all blobs are read from the db.
        Usely we save only references to blobs in an entity bean. And the
blob itself on disk or in a seperate table on the database (Sybase in our
case). Both works well.

        So my recommendation is to check, if blobs are only read form the db
if this is really necessary.

        Andreas 

_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to