Re: Batching creation of primary keys with Oracle
Re: Batching creation of primary keys with Oracle
- Subject: Re: Batching creation of primary keys with Oracle
- From: Guido Neitzer <email@hidden>
- Date: Fri, 25 Apr 2008 15:57:17 -0600
On 25.04.2008, at 13:41, Mike Schrag wrote:
I will second this ... It doesn't seem like it would matter much,
but in bulk operations, especially, it actually ends up being a
pretty significant cost. I added batch key generation to FB a while
back and it was a big win.
Yeah, I know that it adds up - it's why I use ERXLongPrimaryKeyFactory
for one application that more or less does 90% inserts.
Btw, is there a specific reason why the "create table" statement in
ERXLongPrimaryKeyFactory creates an "Integer" column and not a "long"
or "bigint" as it is supposed to do:
con.createStatement().executeUpdate("create table pk_table
(eoentity_name varchar(100) not null, pk_value integer)");
Another hint for FrontBase: Don't use EOF 24 Byte primary keys for
tables that get BIG. Insert performance seems to degrade heavily as
you need an index on that column and FrontBase seems not to be the
fastest inserting with that configuration (I saw insert performance
degrading to 500ms for such a table with some 10 million rows on an
Xserve G5).
cug
--
http://www.event-s.net
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden