bytea performance tweak

From: Andreas Schmitz <schmitz(at)occamlabs(dot)de>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: bytea performance tweak
Date: 2011-06-21 13:08:11
Message-ID: 20110621130713.GB3919@summalogicae.occamlabs.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

I've noticed that fetching a bytea field produces a lot of overhead when
converting into a byte[] or InputStream. Looking at the code, I've
produced a small patch (a lookup table for the hex codes) which makes
the conversion faster. What do you think?

Best regards, Andreas

Attachment Content-Type Size
patch text/plain 2.7 KB

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2011-06-21 23:59:07 Re: bytea performance tweak
Previous Message Bruce Adams 2011-06-17 02:20:18 Re: Failover Datasource?