Re: BLOBS in the database

Howard,
 I haven't tried it yet but after reading your responses I will; especially after you said you would test it in your message timed at 12:58, followed by your 'gobsmack' response timed at 13:43! Less than an hour and your a convert!
I think Ammara could use that in their marketing. Maybe they owe you something from their advertising budget?

George Barbour
:-)

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:3b0a6ac9$1_at_news.iprimus.com.au...
> Hi George...
>
> Well clearly, it's not Oracle's fault. Some might say it's mine for
 daring
> to use Access as a front end (blame it on years of VB developing)!
>
> But using Ammara's product, it becomes awfully apparent that Oracle has
 been
> meekly storing whatever the front-end throws at it, big or small. The
 issue
> is stopping the front-end from deciding to decompress JPEGs before passing
> it backwards, which seems a particularly stupid thing to do. (And
 remember,
> this also happened with a SQL Server backend, so it's not even the ODBC
> driver's fault).
>
> My only question now is why, if Ammara knows how not to be stupid, do the
> standard (free!) front-end tools not do likewise?! Clearly, it can't be
> rocket science. Would love to hear from a Forms developer as to whether
> Oracle is any less dumb.
>
> Have you tried the Ammara thingy, George? I think you'll be as impressed
 as
> I was if you do (or maybe I'm just playing catch up).
>
> Regards
> HJR
> --
> =============================!!=============================
> The views expressed are my own only, and definitely NOT those of Oracle
> Corporation
> =============================!!=============================
>
>
> "George Barbour" <george.barbour_at_gecm.com> wrote in message
> news:3b0a587d$1_at_pull.gecm.com...
> > I hope Oracle have an answer to this one Howard, an awful lot depends on
 it.
> > Lots of folks are looking for an answer that doesn't involve purchasing
 a
> > third party tool,
> > with all respect to Ammara's excellent product.
> >
> > George Barbour.
> >
> > "Howard J. Rogers" <howardjr_at_www.com> wrote in message
> > news:3b09e49a_at_news.iprimus.com.au...
> > > Am I doing something horribly wrong here? I have around 100 JPEGs I
 want
> > > stored within the database (ie, as a BLOB, not merely a BFILE). Not
 one
 of
> > > these pictures is larger than around 80K. I've just loaded 50 of
 them,
 and
> > > I'm up to 106 *MEGS* of storage.
> > >
> > > I haven't done much work with BLOBS before, and I expected a bit of
> > > fluffiness with these things, but not quite so fluffy that I need to
 buy
 a
> > > new hard disk to complete the project, thanks very much!
> > >
> > > 8.1.7 on W2K, graphics are being loaded via an OLE Linked object frame
 in
> > > Access, via ODBC. I'm using an 8K block.
> > >
> > > I've seen this same behaviour on, >cough<, SQL Server 2000, so I
 suspect
> > > it's an intrinsic feature of the way these things are stored
 internally,
 but
> > > I'm surprised if so that it appears so *very* inefficient. Any
 suggestions
> > > for different ways to go about this, gratefully received. The thing
 is,
> > > after this I'm scaling up to around 8000 graphics, some rather larger,
 and
> > > the whole point is that I do not want 8000 separate JPEG files
 floating
> > > around on my hard disk.
> > >
> > > Where are the good developers when you need one, huh??!
> > >
> > > Regards
> > > HJR
> > > --
> > > =============================!!=============================
> > > The views expressed are my own only, and definitely NOT those of
 Oracle
> > > Corporation
> > > =============================!!=============================
> > >
> > >
> > >
> > >
> >
> >
>
>
Received on Tue May 22 2001 - 10:09:27 CDT