From: Frank Morton <fmorton@base2inc.com>
To: pgsql-interfaces@postgresql.org
Subject: JDBC Performance Help Needed For inserts
Date: Thu, 19 Nov 1998 17:34:30 -0500
Message-ID: <000301be140c$c6a3cfe0$8355e5ce@tesla.base2inc.com> (raw)
I need some advice related to JDBC performance.
I have an application that might do 200 inserts
in a batch. Right now, it is taking 120 milliseconds
or so per insert, so it adds up to a substantial
amount of time, especially since this is an application
where a user is waiting for it to complete.
Disk activity during this insert period is very high.
It is acting as if LOTS of activity is happening with
each insert. Is the auto-commit feature killing the
performance? These are relatively unimportant inserts,
so if I can defer commits to the end, it is of minor risk
to loose the inserts. These are temporary entries.
Is there a way to temporarily turn commits off for a batch
of inserts, waiting until the end?
Am I missing something? It seems awfully slow.
I am running 6.3.2 under Solaris.
I'd appreciate advice from you all who have been through
this. Thanks.
_________________________________
Frank Morton (fmorton@mail.base2inc.com)
Voice: (317) 876-3355
FAX: (317) 876-3398
Home: (317) 574-0815
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: fmorton@base2inc.com
Subject: Re: JDBC Performance Help Needed For inserts
In-Reply-To: <000301be140c$c6a3cfe0$8355e5ce@tesla.base2inc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox