From: Brad Pepers <brad@linuxcanada.com>
To: ALPESH KOTHARI <alpeshkothari@yahoo.com>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Speed of Postgres with Java
Date: Sat, 04 Dec 1999 03:24:43 -0700
Message-ID: <3848EBEB.910DE62A@linuxcanada.com> (raw)
References: <19991204031143.17192.qmail@web1102.mail.yahoo.com>
ALPESH KOTHARI wrote:
>
> Hello,
>
> I am using Postgres-6.5 as my database. I have to
> create and query db using Java (with JDBC). I am using
> P-III with 128 MB of RAM.
> Consider that following data structure is being stored
> in db.
> (int4,int4,varchar(50),int2,int4)
> To store such 1000 data it takes as large as 90
> seconds. I don't have any pre-experience using db.
> So, is this much time OK?
> I expect someone to comment who have used db with Java
> thoroughly.
You've turned off auto-commit right and just do one commit at
the end? Otherwise its doing a lot of work for each record
added. In general when you are doing bulk inserts, you want
to turn off some of the database features to gain speed.
Make sure auto-commit is off and then post the results. I
bet they are *way* faster!
--
Brad Pepers
Linux Canada Inc. Home of Linux products in Canada!
http://www.linuxcanada.com Proud supporter of Cyclades, Red
brad@linuxcanada.com Hat, and Caldera.
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: brad@linuxcanada.com, alpeshkothari@yahoo.com
Subject: Re: [INTERFACES] Speed of Postgres with Java
In-Reply-To: <3848EBEB.910DE62A@linuxcanada.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