Re: Which NEXT_ID ?

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu Oct 02 2003 - 11:13:27 EDT

Next message: Craig Ziesman: "Re: newbie - Cayenne, Ant, JBoss?"

Previous message: Jean-Paul Le Fèvre: "Which NEXT_ID ?"
In reply to: Jean-Paul Le Fèvre: "Which NEXT_ID ?"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On Thursday, October 2, 2003, at 05:02 AM, Jean-Paul Le Fèvre wrote:

>
> I'm currently using cayenne with MySQL. The primary key generation
> is based on the table AUTO_PK_SUPPORT but I do not understand how
> the next id is computed. My AUTO_PK_SUPPORT was copied from somewhere
> and the default value for NEXT_ID is 20. Is 20 a magic number ?
> Why not simply 1 ? Is it possible to use the auto_increment feature
> of MySQL ?

"20" is default primary key range cache size. This is a performance
improvement feature. This has been discussed before:

http://www.objectstyle.org/cayenne/lists/cayenne-user/2003/08/0031.html
http://www.objectstyle.org/cayenne/lists/cayenne-user/2003/08/0033.html

Andrus

Next message: Craig Ziesman: "Re: newbie - Cayenne, Ant, JBoss?"
Previous message: Jean-Paul Le Fèvre: "Which NEXT_ID ?"
In reply to: Jean-Paul Le Fèvre: "Which NEXT_ID ?"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Thu Oct 02 2003 - 11:13:24 EDT