Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
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

Responses

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group