Re: jdbc batch performance problem

From: Barry Lind <blind(at)xythos(dot)com>
To: pginfo <pginfo(at)t1(dot)unisoftbg(dot)com>
Cc: "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: jdbc batch performance problem
Date: 2003-07-21 20:33:48
Message-ID: 3F1C4E2C.8050809@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Currently there is no difference between inserts done serially or done
via the batch interface. In both cases there is one round trip per
insert. This is an area of the code that would welcome contributions.

--Barry

pginfo wrote:
> Hi,
>
> I am using pg + jdbc for j2ee development from a long time.
> The main problem I found is the very bad insert performance.
> I am using addBatch and executeBatch for minimum network trafik,
> but it is also very slow.
> For example if I try to insert 1000 rows ( in one transaction) into very
> simple table
> it takes ~ 3000 ms. If i use insert into myTable select ... it takes
> only 10 ms.
>
> Exist any basic performance problem for pg jdbc or I make mistake?
> Also I testet the same example on oracle 8i and mysql.
> It is working much much better.
> I love pg but it will be great if I can make insert faster.
>
> Many thanks,
> ivan.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2003-07-21 20:48:59 Re: [Fwd: Array.getArray ()]
Previous Message Dmitry Tkach 2003-07-21 20:31:33 Re: IN clauses via setObject(Collection) [Was: Re: Prepare