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 protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
