Hi.

Yesterday I stumbled over ERXLongPrimaryKeyFactory - while looking for other things and I'm interested in hearing some experiences with this.

It seems to implement the old "eo pk table" approach, well known from OpenBase.

Currently I'm working on a project where I really don't know how big some tables in a database may become (some of them may become really big), so I'm not sure whether I should go with integer primary keys (32 Bit) and I'm also not sure whether to go with db created primary keys (perhaps issues when using a multi master cluster).

For now I have chosen to use 24 byte binary primary keys generated by EOF, but I'm not really happy with them. They are hard to use with other tools, even when just doing some fetches for one row in the db tool just to test something.

It may also get hard to use the DB from any other technology then WebObjects.

So, do you use the ERXLongPrimaryKeyFactory? Or just db created primary keys (what type?)? Or the binary pks from EOF?

Thanks for opinions.

cug


_______________________________________________
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]

Reply via email to