I would agree if this was not a continuation of the the "Analyze of a Blob" thread - which from what I understand isn't talking about serving media from the database, but instead we are talking about getting fielded data from 20 MB BLOB.
Larry On 9/18/06, Clinton Begin <[EMAIL PROTECTED]> wrote:
Well, to be fair Larry, there is data that is stored in databases that cannot be broken up -- not with an RDBMS or with Prevayler or anything else. Movies, music, images, you know...porn. j/k ;-) Seriously though, this is a valid requirement, it's just not something that needs to be "mapped" with iBATIS or anything else. It's data meant for raw streaming to the client. Now, if it's 20MB worth of XML, then I'd be worried. Cheers, Clinton On 9/18/06, Larry Meadors < [EMAIL PROTECTED]> wrote: > Well, without knowing more of the requirements, it's hard to say, but > in almost all cases, the first step would be to break it into > managable components and data structures. > > A 20MB blob is not a data structure. > > Maybe you are looking for something more like Prevayler. > > Larry > > > On 9/18/06, soussou97 <[EMAIL PROTECTED]> wrote: > > > > Hi Larry > > > > I have realized of performance with Ibatis and JDBC for getting of BLOB, in > > conclusion when the size is important, Ibatis is not adapted for this kind > > of situation. > > For your question : "Reading a 20M blob to create objects? This just sounds > > to me like an > > application from Hell" > > Which solution you propose ? > > > > Regards; > > > > Larry Meadors-2 wrote: > > > > > > Nope. > > > > > > Why are you using a RowSet? > > > > > > If I were doing this, I'd use a simple prepared statement to a result > > > set to do it. > > > > > > Reading a 20M blob to create objects? This just sounds to me like an > > > application from Hell. > > > > > > Larry > > > > > > > > > On 9/18/06, soussou97 < [EMAIL PROTECTED]> wrote: > > >> > > >> Hi Larry; > > >> > > >> OK I willl ue JDBC + Rowset for getting the blob, have you a example or a > > >> implementaition ? > > >> > > >> Regards; > > >> > > >> > > >> Larry Meadors-2 wrote: > > >> > > > >> > For 20M of data? No. > > >> > > > >> > Larry > > >> > > > >> > > > >> > On 9/18/06, soussou97 <[EMAIL PROTECTED]> wrote: > > >> >> > > >> >> Hi; > > >> >> > > >> >> Please somebody can answer me if its possible to use Ibatis (last > > >> >> version) > > >> >> for getting a big Blob (20 Mo) from a database (Oracle 10) with of the > > >> >> good > > >> >> performance ? > > >> >> If yes which lib (InputStream or sql.Blob) I must to use for > > >> extracting > > >> >> the > > >> >> data inside of blob (byte []) ? > > >> >> > > >> >> regards; > > >> >> -- > > >> >> View this message in context: > > >> >> http://www.nabble.com/Ibatis-and-the-blob-tf2290439.html#a6361369 > > >> >> Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > > >> >> > > >> >> > > >> > > > >> > > > >> > > >> -- > > >> View this message in context: > > >> http://www.nabble.com/Ibatis-and-the-blob-tf2290439.html#a6362935 > > >> Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > > >> > > >> > > > > > > > > > > -- > > View this message in context: http://www.nabble.com/Ibatis-and-the-blob-tf2290439.html#a6364829 > > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > > > > >
