From: | Kris Jurka <books(at)ejurka(dot)com> |
---|---|
To: | Mike Clements <mclements(at)actional(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Batch with keygen? |
Date: | 2005-11-07 21:18:31 |
Message-ID: | Pine.BSO.4.61.0511071615580.17958@leary.csoft.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On Mon, 7 Nov 2005, Mike Clements wrote:
> I've got a bunch of PreparedStatements doing inserts on tables with
> primary keys generated by sequences. For example, insert on table A,
> take generated primary key, insert on table B assigning foreign key
> generated value for A's primary key.
>
> For performance reasons, I need to batch these commands. But I don't see
> how it would be possible to continue using this approach with a batch of
> commands, because I need the results of the first insert to make the
> second insert. Is there some way to do this or am I going to have to
> stop using keygen and instead have my application generate its own keys?
>
One option would be to tune your sequence generator to your batch size,
consider: CREATE SEQUENCE myseq INCREMENT BY 100; Then if you fetch a
nextval you know that you are also free to use the next 99 values as well
in your batch statement without touching the sequence.
Kris Jurka
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2005-11-08 00:01:04 | Re: Batch with keygen? |
Previous Message | Kris Jurka | 2005-11-07 19:53:10 | Re: Using WebRow set with Postgresql JDBC drivers... |