Globally unique IDs
Globally unique IDs
- Subject: Globally unique IDs
- From: "Colin O'Brien" <email@hidden>
- Date: Fri, 6 Feb 2004 13:45:07 -0500
Hi,
we are working on a new system, where we will be moving data between
different databases.
This will require objects with a simple ID that is globally unique.
It seems the automatic private key mechanism in WO only provides unique
keys within a single database.
It seems we could get a truly unique ID using VMID.
It further seems we could create our own "PK's" in awakeFromInsertion.
The questions then would be
* is there going to be a noticeable performance hit using VMID's (40
bytes) compared to the more typical int?
more concerned about retrieval performance than update performance
* would it be better to use the built-in PK system and have a separate
column for the VMID?
particularly thinking about how relationships might work
We are planning on using MySQL.
We looked at both MySQL and PostgreSQL and while PostgreSQL seems the
better database system, MySQL seems better supported in WO.
Thanks for any help
Colin
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.