Re: BLOBS in the database

Trust me George: When the Lord got round to handing out developer skills, he found me in the back row (just in front of the Java developers). If the thing had required great gobbets of code to make it happen, I'd have been sunk. As it was, I clicked 'Help', found the bit about the code for loading an image (it's a one-liner), and stuck that behind my OK button. And that's all there was to it. I spent most of the hour wandering around their website wondering what the catch was!

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:3b0a7f3a$1_at_pull.gecm.com...


> 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

> > > > =============================!!=============================

> > > >

> > > >

> > > >

> > > >

> > >

> > >

> >

> >

>

>