XPost: comp.database.oracle, comp.database.oracle.misc, comp.dat   
   bases.oracle.misc   
   XPost: comp.lang.java.help, comp.lang.java.programmer   
   From: zaphod@no.texas.spam.net   
      
   "bigbinc"  wrote in message   
   news:d1b33313.0401081044.27ac8238@posting.google.com...   
   *made bottom post*   
   > Thomas Schodt  wrote in message   
   news:...   
   > > "Ryan Stewart"  wrote in   
   > > news:TIadnSzOONjJMkWiRTvUrg@texas.net:   
   > >   
   > > > and it works for small files,   
   > > > but larger ones ... give an   
   > > > error saying that the data is too large for the field.   
   > > > Any solutions/help/nudges in the right   
   > > > direction are greatly appreciated   
   > >   
   > > As a workaround store big files as several slices of 4k (or whatever the   
   > > limit is) (maybe in a new table - with a slice-# as part of the key) and   
   > > reassemble them at retrieval time.   
   > This is cool stuff, Is there anyway to implement a sort of Network   
   > File System using Oracle using blobs.  The question is, will this kill   
   > the oracle server?   
   > Will the performance being in better using File I/O for example using   
   > servlets?   
   >   
   > I would like to try it but I hate to mess up our server for doing so.   
   > Are there any benchmarks?   
      
   That's pretty much what I was/am doing: making a file-sharing system. We   
   managed to get around the 4k limit by bypassing certain things and manually   
   inserting the file data into the database.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)