"bigbinc" <bigbinc@hotmail.com> wrote in message
news:d1b33313.0401081044.27ac8238@posting.google.c om...
*made bottom post*
> Thomas Schodt <news0310@xenoc.$DEMON.co.uk> wrote in message
news:<Xns945592D0EE3A4xenoc@158.152.254.254>...
> > "Ryan Stewart" <zaphod@no.texas.spam.net> 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.