Large binary data [was: contrib: hack for psycopg2 performance]

Daniele Varrazzo <[email protected]> Wed, 12 May 2010 14:12:20 +0100

Newsgroups	gmane.comp.python.db.psycopg.devel
Message-ID	<[email protected]>

On Wed, May 12, 2010 at 1:52 PM, Karsten Hilbert
<[email protected]> wrote:
> On Wed, May 12, 2010 at 01:26:53PM +0100, Daniele Varrazzo wrote:
>
>> > Because *Params offers a quantitative advantage (speed) and
>> > a qualitative advantage (*ridding* oneself of SQL injection).
>>
>> Do we have a measure of the speed advantage?
>
> Not really (beyond the one the OP posted). Common
> (PostgreSQL) wisdom holds that it is advantageous when
> dealing with significant amounts of truly binary data (such
> as bytea) - which I am (medical documents).

Aren't large objects more suitable to deal with them?

-- Daniele