0 Replies Latest reply on Aug 9, 2004 6:59 PM by vying

    Performance issues of using BLOB in CMP

    vying Newbie

      Hi all,
      I am wondering if you guys have experience on how CMP can handle BLOB type,Since I plan to use a BLOB type to store large file data(100MB-1GB) into a table using CMP and then read it back later on.I am trying to be clear about any potential performance hit before I do that approach.
      Now if I do File I/O directly it take about 16 secs to write a 70MByte file to my local directory,is that can be achieved in EJB CMP/or direct JDBC calls?Then how about reading performance.
      I am using Jbsoo3.2.3 and Oracle9i,
      Any special attentions I should pay to If I use CMP approach?
      Thanks a lot in advance