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