Re: Large Objects

Joshua D. Drake wrote:

> Frank D. Engel, Jr. wrote:
>
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> I'd advise use of BYTEA as well.  It's much simpler to work with than
>> the OIDs, and has simpler semantics.  You do need to escape data
>> before handing it to the query string, and handle escaped results
>> (see the docs), but overall much nicer than working with OIDs.
>
>
> BYTEA is not always pragmatic. What is the file is 100 megs? 256 megs?
>
Intresting.
What is the size when bytea become inafective ?

Currently i keep all my products images in bytea record. is it practical ?

how slower is it then accessing an image on a file system ( like ext3 ) ?

Cheers

>
> pg_largeobject is more efficient than BYTEA for larger binaries.
>
> Sincerely,
>
> Joshua D. Drake
>
>

--
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Cel: 972-52-8555757
Fax: 972-4-6990098
http://www.canaan.net.il
--------------------------